How do I give a user permission only on a database?

How I can give permissions to user on only one table in a DB in SQL Server?

Using the UI you can use the User Mapping tab under the login, you can create the user with 'public' access only. Then you can go to the database and grant that user SELECT access to the particular table (by clicking the oddly named "Search" button under Securables tab).

How do you grant Users access to a specific database?

Database-Specific Privileges To GRANT ALL privileges to a user , allowing that user full control over a specific database , use the following syntax: mysql> GRANT ALL PRIVILEGES ON database_name. * TO 'username'@'localhost';

How do I give a user access to an SQL database?

Procedure1In the SQL Server Management Studio, open Object Explorer.2Click Server_instance_name > Security > Logins.3Right-click Logins and select New Login.4On the General page, in the Login name field, type the name for a new user.5Select SQL Server authentication.6In the Password field, type a password for the user.Creating a user and granting permissions - IBM

How do you make a database user read only?

After you have created a user you will need to grant permission to all the database tables one by one. Doing so you can use a loop: BEGIN FOR R IN (SELECT owner, table_name FROM dba_tables WHERE owner='schema_name') LOOP EXECUTE IMMEDIATE 'grant select on '||R.