{permissions} How should I do this?
- From: "Jeff" <Jeff@not_a_real_email_address>
- Date: Tue, 26 Feb 2008 09:29:42 +0100
Hey
We are using Sql Server 2005. Our database server is a win2k3 machine. We
have Active Directory etc
Now we want an external user to get access to one of our data systems. He
needs ddl/read/write permissions on a specific database and also read/write
permissions on some folders on the harddrive on the server.
I think I can accommplish access to the database by assigning the user to
these database roles: db_datareader, db_datawriter, db_ddladmin....
The biggest problem is how to give this user access to the folders. If I
create him in AD then he becomes member of Domain Users group which means
that he has access to everything Domain Users has access to. I tryed to
remove the Domain Users group from this user, but did get a message that I
couldn't do it because this was the default group... If this user is member
of Domain Users, then he has access to much in our network...
(I have the impression that if I change what is the default group, then I
have to apply this change to all users in AD)
any suggestions?
.
- Follow-Ups:
- Re: {permissions} How should I do this?
- From: Roger Abell [MVP]
- Re: {permissions} How should I do this?
- Prev by Date: Re: Strong passwords and user locking?
- Next by Date: Re: {permissions} How should I do this?
- Previous by thread: Strong passwords and user locking?
- Next by thread: Re: {permissions} How should I do this?
- Index(es):
Relevant Pages
|
