Interested to Buy Any Domain ? << Click Here >> for more details...
Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5806 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
Can a table have 2 foreign keys?
What are the different kinds of ssrs reports?
What is cursors?
How can you check the version of sql server?
Explain error handling in ssis?
Which is the latest version of sql server and when it is released?
mention different types of relationships in the dbms?
What are the different types of upgrades that can be performed in sql server?
what's sql server? : Sql server database administration
what are different types of backups available in sql server? : Sql server database administration
What is SubQuery in SQL Server 2008
How each E-R model constructs can be mapped to the relational model?
Define normalisation?
What are the advantages of using cte?
How to display a past time in days, hours and minutes?
