assigning DB-user to server role
From: M.Staiger (mstaiger_at_informatik.uni-siegen.de)
Date: 01/27/04
- Next message: Rick: "Re: Perms on Tempdb?"
- Previous message: Eliyahu Goldin: "SSL on published SQL Server"
- Next in thread: Dan Guzman: "Re: assigning DB-user to server role"
- Reply: Dan Guzman: "Re: assigning DB-user to server role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 27 Jan 2004 12:32:43 +0100
Hello NG,
each time we assign users to roles, we have to additionally grant each
access right of each function of each table manually to this new user. Of
course we'd expect this to be done by the assignment itself.
Either we don't understand the servers's security philosophy correctly or
there should be another procedure to grant users access to the database via
the role, which has already defined access rights.
Thankful for any hint ...
Marc
- Next message: Rick: "Re: Perms on Tempdb?"
- Previous message: Eliyahu Goldin: "SSL on published SQL Server"
- Next in thread: Dan Guzman: "Re: assigning DB-user to server role"
- Reply: Dan Guzman: "Re: assigning DB-user to server role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
