Interested to Buy Any Domain ? << Click Here >> for more details...
Security Question- SQL DBA exparts, need your help...
- 3 Answers
- 5683 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
Tell me what is difference between view and materialized view?
What are a scheduled jobs or what is a scheduled tasks?
Give the query of getting last two records from the table in SQL SERVER?
What is the difference between varchar and nvarchar?
Can we use where clause in union?
Why do we use trigger?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is the difference between ‘having’ clause and a ‘where’ clause?
What is meant by referential integrity?
What is SQL Azure Data sync?
Explain syntax for viewing trigger?
What is the difference between an index and a unique index?
What is fill factor and pad index?
What is the maximum size of sql server database?
Explain what is lock escalation?
