Security Question- SQL DBA exparts, need your help...
Answers were Sorted based on User's Feedback
Answer / sqldba29
I want to give access to a new user (example "user A") same
access as another existed user for (example "User B'").
User B has access to 8 databases in one server... (Read,
write, ddl)
My question is, what are the ways to give the access
to "User A"... or we have to open each database of "user B'
has and see his/her permissions on that database and then
open the "user A" and give the permission accordingly.
If you are doing any differently please help me.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / kiran
Always prefer giving permissions to a group.mark up the
permissions of a onto a group and then all u need to do is
add the new user to that group.this is the most efficient
way that new users can be added with same permissions as
that assigned to previous users.
Is This Answer Correct ? | 0 Yes | 0 No |
How to use subqueries with the in operators in ms sql server?
Find first and last day of current month in sql server
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...
Explain syntax for viewing, dropping and disabling triggers?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is your recommendation for a query running very slow? : sql server database administration
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.
How to find Duplicate Records In table?
How do I port a number to sql server?
how to retrive only second row from table in sql server 2000?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
How much memory that we are using in Logshipping Concept?