Enterprise Manager - Permissions 1

[Murugs]

I am sure there is a way to do this..But cannot figure it how do I do this.

I need to give read only access for databases and full access permission to just 1 database to a user in SQL enteprise manager. Is this possible..I am trying to figure out, but not much help though and most newsgroups say it is not possible in SQL enterprise manager. I use SQL Server 2000.

 

[DrSql]

Yes its possible.
From EM, Drill down to security==>Logins==> Double click on the user..
Goto Database Tab, slect the DB you want give read only,and select db_datareader from the database roles and simlary give db_owner from the DB for full permissions. This will give acess only db level, rather than server level. To test this processs create a new user and apply it.

Dr.Sql
Good Luck.

 

[Murugs]

That was a fast response..Thanks DrSql.
I created a test login and assigned permissions appropriately.

I have a basic question. Now I login to the w2k3 server as administrator and then I launch enterprise manager with no problems.

I need a particular domain user to grant access to enterprise manager. He uses RDP to login to the server using his own domain logon and id. How can I link the EM test login to the domain login..Sorry I am newbie to SQL server administration.

 

[DrSql]

Is this a Terminal or Citrix environment you need think about creating some policies that grant access to the EM shortcut. If you are in the clent level, then let them access the EM, but they wont be able to access any funtions because the prvilages locked by SQL Server. So think about policy..Or give everyone a shortcut on desktop by copyin a shortcut of EM in Document Settings\All Users\Desktop

World Class Free Service..At no cost..

Dr.Sql
Good Luck.

 

[Murugs]

Thanks for the help..I am trying out a few things and seems it is working for me.

 

[mrdenny]

Better yet install Enterprise Manager on his workstation and have him use it from there with out RDPing to the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief