Permissions for database
From: Richard Siddaway (rsiddaw@hotmail.com)
Date: 08/21/02
- Next message: Jakub Jablonski: "Enforcing password change"
- Previous message: Michel: "Permissions for database"
- In reply to: Michel: "Permissions for database"
- Next in thread: Steve: "Permissions for database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Richard Siddaway" <rsiddaw@hotmail.com> Date: Wed, 21 Aug 2002 04:24:05 -0700
Assuming your server is part of a domain:
- Ensure SQL Server can use Windows Authentiaction- create
a domain level group containing your developers
- create a SQL Server login for that group - either use
Enterprise Manager or use sp_grantlogin
- link the login to the databases you want the developers
to access
- assign relevant database level permissions to the
developer group
>-----Original Message-----
>Hi!
>We have several databases on SQL-Server with a number of
>developers. To define a user to access to a database we
>make him a local administrator on a server. We'd like to
>change this to something more useful as defining
>permissions for developers without making'em
>administrators. We tried to define login for a database,
>but it hasn't succeeded.
>We'd appretiate any help from you on the issue above.
>Thanks in advance.
>.
>
- Next message: Jakub Jablonski: "Enforcing password change"
- Previous message: Michel: "Permissions for database"
- In reply to: Michel: "Permissions for database"
- Next in thread: Steve: "Permissions for database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
