Re: user wants access
From: Dooma (Say-no-to-spam_at_hotmail.com)
Date: 12/14/04
- Next message: JTC ^..^: "Re: Question about trigger"
- Previous message: ChrisR: "Re: SQL Agent refuses to use non-default profile"
- In reply to: Mark Allison: "Re: user wants access"
- Next in thread: Dooma: "Re: user wants access"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Dec 2004 12:45:06 -0500
Yes I am new to this. I am the network admin. we have a consultant who built
the database for us. He is not available now. I wanted to give the product
manager access to the database in SQL. He is set there as an admin. He will
be doing some light configuration to our AD users. He is very reliable and
he is my boss. My question is how can he have access to the database from
his machine. I do not know how SQL works so I do not know to phrase the
question. I hope you know what I mean.
"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
news:ORUR70f4EHA.1452@TK2MSFTNGP11.phx.gbl...
> 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: JTC ^..^: "Re: Question about trigger"
- Previous message: ChrisR: "Re: SQL Agent refuses to use non-default profile"
- In reply to: Mark Allison: "Re: user wants access"
- Next in thread: Dooma: "Re: user wants access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
