Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5095 Views
- I also Faced
- E-Mail Answers
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 are orphan records?
What is the difference between index seek vs. Index scan?
When would you use it?
Do you know exporting and importing utility?
What will be the maximum number of index per table?
Explain identity in sql server?
How to loop through result set objects using odbc_fetch_row()?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What are the features of Embedded SQL
what are database files and filegroups? : Sql server database administration
what are the different ways to return the rowcount of a table?
How many columns can exist together per table?
Explain throw statement in sql server 2008?
How does using a separate hard drive for several database objects improves performance right away?
application server is slow what may be the problem
