Posted by masri999 on 09/21/06 10:03

I have a requirement in SQL 2005 in Development database

1. Schema dbo owns all objects (tables,views,SPs,UDFs etc) .
2. Only DBA's ( who are database owners ) can create, alter tables .
Developer's should not create or alter tables .
3. Developers can create/alter Stored Procedure/User Defined functions
in dbo schema and can execute SP/UDF.
4. Developers should have SELECT,INSERT,DELETE,UPDATE on tables (
tables in dbo schema

How to achieve this using GRANT SCHEMA statement

Thanks

M A Srinivas

• Next in forum: data is not exporting to excel in sql server 2005 client edition
• Prev in forum: Re: SQL server connection
• Thread view: Create Procedure Permission ONLY

[Reply to this message]