Interested to Buy Any Domain ? << Click Here >> for more details...
Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5538 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
What is RMS migrations?
Explain multiserver query
How to how to convert numeric expression data types using the convert() function??
what is a sub-report?
Explain contrast amongst grouped and non-bunched records?
Is it true, that there is no difference between a rule and a check constraint?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What are the events recorded in a transaction log?
Explain Geography datatype in SQL Server
How to check if stored procedure is running in sql server?
Why would you use sql agent?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What are the differences between lost updates and uncommitted dependencies?
Explain the advantages of merge replication?
Is sql server is free?
