Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5093 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can I change procedure name in sql server?
What is difference between index and primary key?
What is difference between delete and truncate commands?
What is the main purpose of having conversation group?
What are the extra roles available in msdb? : sql server security
Is it important for a database administrator to understand the operating system and file access?
What is compound operators?
What are the acid properties?
Do you know how to implement service broker?
What is acid mean in sql server?
Explain some stored procedure creating best practices or guidelines?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
can you instantiate a com object by using t-sql? : Sql server database administration
Where is my database stored on the hard disk in ms sql server?
What is the sql server agent?
