answersLogoWhite

0

To grant write permissions to a user in a database, you can use SQL commands like GRANT INSERT, UPDATE, and DELETE privileges on specific tables or databases. This allows the user to add, modify, and delete data in the database.

User Avatar

AnswerBot

4mo ago

What else can I help you with?

Related Questions

What is a user name in a database?

It can refer to someone who can use the database. There may be security on it, meaning they have to log on to use it or do some things with it. They would be given an account, and as part of that they would have a user name an a password.


How is security implemented in a relational database?

Security is one of the key concern of a database administrator. Security can be added to the user, object etc. An object (table,views,stored procedures etc) can have multiple permissions. A database administrator can grant revoke permissions to the objects. Security is implemented based on the data sensitiveness also. If there is a table for password, make sure that only it's encrypted and can be accessible through administrator only.


Which permission will you grant a user for a folder he need to be able to create and delete files in if you do not want him to be able to change permissions for the folder?

Write, Access control lists are used to specify the permissions that users will have to resources on the network. The Write permission allows a user to modify folders and files that already exist in the environment as well as create new files and folders as required.


What are write persmissions?

If a user has write permissions then that user is able to Delete or Modify that file. In the case of directories it means that user can create, delete, modify files in that folder.


Difference between user and schema for DB2?

In DB2, a user is an individual who is granted permissions to access and interact with the database, while a schema is a named collection of tables, views, procedures, and other database objects owned by a user. Users are associated with schemas to define their default schema for objects they create.


Difference between grant and revoke statements in sql?

grant will give permission to the user on database by using revoke we can remove the permission


What are the differences between User and Administrator accounts?

An admin account allows for the user to have all the permissions to the computer and is known as the top level user. A user account has some permissions but not full access permissions to the OS that an admin would have. Based on greater permissions: 1. Admin 2. User 3. Guest


What does the permissions assigned to a user account do?

The permissions helps to restrict/monitor the movement(accessing of resources) of the user in the domain.


When a user or group is not listed on the Security tab for an object does that user or group have no effective permissions to that object?

Yes, they have no effective permissions.


How can you set the permission of file server?

You can use the Server app to set standard permissions-Read & Write, Read Only, Write Only, or None-to control access to a folder and its contents. You can set different permissions for one user (the owner), one group, and all other users who log in. You can also set standard permissions on individual files. Standard permissions are also called POSIX permissions.


How do you let other people join so they can write on your blog on wordpress?

In order to have more people be able to publish posts on a wordpress blog the administrator of the blog will need to grant permissions to people by adding usernames/password with specific read/write permissions. dashboard > users > add new user > then add them as either an administrator, contributor, editor > save They then have the ability to add content to your site


What do you understand from file permissions?

@Linux : for an example : for a file named " lastlog " Here are its permissions : -rw-r--r-- 1 root root 29492 Dec 1 15:12 lastlog Which means-- here( r )stands for -----Read (w)stands for -----Write and (x)stands for -----Execute Permissions respectively In Detail: User has rw- Permissions(read,write permissions and no execute permission) Group has r-- Permissions and Others have r-- Permissions for the file lastlog* . Extra info : root root ----Means that it is owned by root user(first root) and it belongs to group root (second root). Hope it helped.