Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How do I find the port number for sql server?

1013


How to how to convert numeric expression data types using the convert() function??

1089


What is the advantage of sql server?

1078


Is it possible to call a stored procedure within a stored procedure?

1024


What is CTE in SQL

990


What is self contained multi valued query?

1069


Differentiate between a primary key and a unique key.

1111


What are the types of table?

1026


How do I view a trc file?

975


Can we use max in where clause?

979


How do I find the transaction log size in sql server?

1000


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1295


Define cross join in sql server joins?

1073


how to do partition in sqlserver

2539


Explain some stored procedure creating best practices or guidelines?

1000