Re: SQL Server 2005 AND Security (Please Help)
- From: "David Gugick" <david.gugick-nospam@xxxxxxxxx>
- Date: Fri, 20 Jan 2006 17:56:40 -0500
Shabnam Gupta wrote:
Hello Everyone, I am new to SQL server 2005 and I am not very familiar with how the permissions work. In SQL 200 I had a role setup and all the permissions were granted to the role and users were given the role.
In SQL 2005 my manager wants me to Create a schema for the role and all the web applications should use this schema and only execute access on the stored procedures should be given for the applications.
can someone help me with step by step instructions on how to do this?
Thanks Shabnam Gupta
- Create the schema (CREATE SCHEMA)
- Add the objects to the schema (CREATE TABLE, VIEW, PROC, etc.)
- Create the role (CREATE ROLE)
- Run the necessary grant for object access for the role (GRANT,DENY, REVOKE)
- Assign users to the role (sp_addrolemember)
- Fully-qualify all object references in your code (schema.object or database.schema.object)
You can also create tables and issue the grants right from the create schema statement if you want.
--
David Gugick
Quest Software
www.quest.com
.
- References:
- SQL Server 2005 AND Security (Please Help)
- From: Shabnam Gupta
- SQL Server 2005 AND Security (Please Help)
- Prev by Date: Re: MSDE login problem - Windows
- Next by Date: Re: Cached Credentials & Database Diagrams
- Previous by thread: SQL Server 2005 AND Security (Please Help)
- Next by thread: Anti Virus scanning and database files
- Index(es):
Relevant Pages
|
|
