how to disallow a user from creating and modifying trigger but can creating and modifying stored procedure
- From: "Zeng" <zeng@xxxxxxxxxxxxxx>
- Date: Thu, 26 Oct 2006 10:30:40 -0700
Hi,
In sql 2005 (Enterprise edition if it makes any difference) I can't find a
permission combination that allows me to set up a user with following
intentions:
- Cannot modify anything other than create and modify store proc.
- Can execute all stored procs and functions.
- Can view all schema info about the database
Would anyone know how? Thanks!
.
- Prev by Date: Re: Hide databases in EM/QA
- Next by Date: Re: Backing up Encryption Master Key
- Previous by thread: Re: Windows Authentication or SQL Server Authentication
- Next by thread: Re: Backing up Encryption Master Key
- Index(es):