Interested to Buy Any Domain ? << Click Here >> for more details...
Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5514 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
Why normalization is used?
Explain what is the difference between union and union all?
Do you know what guidelines should be followed to help minimize deadlocks?
Mention the command used to rename the database.
Disadvantages of the indexes?
What are the difference between primary key and unique key? : sql server database administration
Do you know what is normalization of database? What are its benefits?
Mention what are the different types of ssrs reports?
Who is the owner of a schema in ms sql server?
What are acid properties of transaction?
how to determine the service pack currently installed on sql server? : Sql server database administration
what is the difference between openrowset and openquery?
What are the purposes of floor and sign functions?
Explain the dbcc pintable command when would you use it?
What is field in algebra?
