Interested to Buy Any Domain ? << Click Here >> for more details...
Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5643 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
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
How to execute function in stored procedure sql server?
Can primary key be null?
What is logshipping and its purpose?
How to create and drop temp table in sql server?
What are the diifferences between the ms sql server vs mysql?
What is set nocount on?
Why do we use stored procedures in sql server?
What gets stored inside msdb database?
How to encrypt Strored Procedure in SQL SERVER?
What are the advantages of policy management?
Can we call future method from trigger?
How to create function with parameter in sql server?
what are the different ways to return the rowcount of a table?
Explain about system stored procedure?
