Security Question- SQL DBA exparts, need your help...

Answers were Sorted based on User's Feedback



Security Question- SQL DBA exparts, need your help... ..

Answer / sqldba29

I want to give access to a new user (example "user A") same
access as another existed user for (example "User B'").

User B has access to 8 databases in one server... (Read,
write, ddl)

My question is, what are the ways to give the access
to "User A"... or we have to open each database of "user B'
has and see his/her permissions on that database and then
open the "user A" and give the permission accordingly.

If you are doing any differently please help me.

Is This Answer Correct ?    3 Yes 0 No

Security Question- SQL DBA exparts, need your help... ..

Answer / dolly rajdev

As you know what all access are provided to the existing "User B".
You can give the same access to the new user "User A".
Run the command ->
GRANT SELECT ON SCHEMA::dbo to User A
likewise u can give the below permissions ->
GRANT INSERT ON SCHEMA::dbo to User A
GRANT UPDATE ON SCHEMA::dbo to User A
GRANT DELETE ON SCHEMA::dbo to User A
All u need to do is just select the Database from the drop-down list in the SQL Server Manangement Studio and run the above scripts once.
If u want the same permission to be given to the same user in 8 databases the select all the databases one by one from the drop-down in SQL Server and run the same scripts.

Is This Answer Correct ?    1 Yes 0 No

Security Question- SQL DBA exparts, need your help... ..

Answer / kiran

Always prefer giving permissions to a group.mark up the
permissions of a onto a group and then all u need to do is
add the new user to that group.this is the most efficient
way that new users can be added with same permissions as
that assigned to previous users.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to restore performance issues and how to check?

0 Answers  


What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,


What is difference between count (*) and count column?

0 Answers  


how many triggers you can have on a table? : Sql server database administration

0 Answers  


Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  


What is the difference between mysql and mysqli?

0 Answers   HCL,


What are alternate keys?

0 Answers  


How to find the source of a table in sql server?

0 Answers  


How to search for a string in all stored procedure in sql server?

0 Answers  


Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,


What stored by the master? : sql server database administration

0 Answers  


How to replace null values in expressions using isnull()?

0 Answers  


Categories