August 5, 2008 at 9:48 pm
hi all,
I had problem in my sql server.
In my PC i used different users accounts for my personal purpose. If i gave Admin prermission to Uers they can open SQL server 2000. But other users can't access SQL2000 (not admin permision users cant log to sql2000).
Can anyone help me to solve HOW TO ACCESS SQL2000 for both kind of users .
thanks
August 6, 2008 at 4:13 am
Did you create Logins in SQL server for the non-admin users?
Sounds like the admin users can access SQL Server through the Built-IN\Adminstrators group while non-admin users have no login/user account in SQL server.
[font="Verdana"]Markus Bohse[/font]
August 6, 2008 at 6:04 am
hi,
How i can give permision for non admin users. ???
Thanks
August 6, 2008 at 6:34 am
1) Open Enterprise Manager
2) Select Security->Logins
3) Right click on existing and select 'Properties'
4) Select 'Database Access' if you want to grant them database roles or 'Server Roles' if they need to be granted Server-wide roles.
That's for logins.
Login maps to the database user:
To manage permissions for particular user go to:
1) Open Enterprise Manager
2) Select 'Databases'
3) Select your database
4) Select 'Users'
5) Right click on existing and select 'Properties'
6) Click 'Permissions' and grant appropriate.
Or check following article for t-sql commands to grant permissions
http://www.mssqlcity.com/Articles/Adm/manage_users_permissions.htm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply