Re: user wants access
From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 12/14/04
- Next message: Rick Sawtell: "Re: SQL Server Error - Through Enterprise"
- Previous message: Re Fo: "Re: Enabling SQL Server Agent by using scripts"
- In reply to: Dooma: "user wants access"
- Next in thread: Dooma: "Re: user wants access"
- Reply: Dooma: "Re: user wants access"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Dec 2004 16:51:43 +0000
Dooma,
I would strongly recommend you read Books Online for this information.
It is clear from your message that you are very new to this product, and
the risk of losing data is high for new administrators. Are you the
administrator?
In order to allow someone to administer users, you need to add them to
the db_securityadmin fixed database role. You do mean database _users_
and not logins don't you? They are different.
-- Mark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602m.html Dooma wrote: > I have SQL 2003 server installed and configured and in use at this moment > on win2003 server. One of my users wants to be able to access the database > so he can add/delete users. He is using win 2000 pro. I never used SQL > before. What do I need to do to allow this person permission to the SQL > database? Do I need to install any kind of client on his machine? Let me > know if you need more info. > > Thanks in advance. > >
- Next message: Rick Sawtell: "Re: SQL Server Error - Through Enterprise"
- Previous message: Re Fo: "Re: Enabling SQL Server Agent by using scripts"
- In reply to: Dooma: "user wants access"
- Next in thread: Dooma: "Re: user wants access"
- Reply: Dooma: "Re: user wants access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
