Security Question- SQL DBA exparts, need your help...
Answer Posted / 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 |
Post New Answer View All Answers
How do I find the port number for sql server?
How to how to convert numeric expression data types using the convert() function??
What is the advantage of sql server?
Is it possible to call a stored procedure within a stored procedure?
What is CTE in SQL
What is self contained multi valued query?
Differentiate between a primary key and a unique key.
What are the types of table?
How do I view a trc file?
Can we use max in where clause?
How do I find the transaction log size in sql server?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Define cross join in sql server joins?
how to do partition in sqlserver
Explain some stored procedure creating best practices or guidelines?