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
What is ssl in sql server?
What happens on checkpoint?
Why does sql studio use a single registered database repository? : sql server management studio
How real and float literal values are rounded?
What are the triggers in sql?
What is sql or structured query language?
Why I am getting this error when renaming a database in ms sql server?
How retrieve field names from the table in SQL through JAVA code?
what are the new features in SSRS?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
ow to bring suspect mode datbase online from scratch
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What are joins in sql and what are the different types of joins?
What is table-valued sub query?
What is the difference between stored procedure and user defined functions?