Interested to Buy Any Domain ? << Click Here >> for more details...
Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5681 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
Which language rdl files made of?
How to find out the list schema name and table name for the database?
What is raid and what are different types of raid levels?
Explain “row_number()” in sql server with an example?
How to connect of datebase with sql express.?
Would you store your query in a ssrs report or a database server? State the reason why?
What do you understand by intent locks?
How can I add Reporting Services reports to my application?
What causes index fragmentation?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What stored by the msdb? : sql server database administration
Explain an automatic checkpoint
What is candidate key with example?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What are the disadvantages of using querystrings to send data from one page to another?
