Interested to Buy Any Domain ? << Click Here >> for more details...
Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5794 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
Explain database normalization?
what is raid and what are different types of raid configurations? : Sql server database administration
What the different types of Replication and why are they used?
How self join is different from outer join?
Which autogrowth database setting is good?
What is difference between order by and group by?
What is the difference between char, varchar and nvarchar?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Can you explain different types of joins?
What is the sql server 2000 version number?
What are alternate keys?
What are different types of statement?
Define views.
What stored by the master? : sql server database administration
What is ms sql server service broker?
