Re: role/permissions to allow SELECT and creating and deleting triggers
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 06/26/03
- Next message: Sandy: "use of application roles"
- Previous message: Jed Ozone: "role/permissions to allow SELECT and creating and deleting triggers"
- In reply to: Jed Ozone: "role/permissions to allow SELECT and creating and deleting triggers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 26 Jun 2003 16:03:47 -0400
Try:
grant create trigger, alter trigger to MyUser
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Jed Ozone" <jed ozone@yahoo.com> wrote in message news:#pRtSxBPDHA.2248@TK2MSFTNGP11.phx.gbl... I'm trying to figure out how to setup a role (or just give a user permssions, since it's only 1 user) on a particular database to have SELECT privileges on all tables (that's easy enough to do), but also allow the user to create and delete triggers (only) in that database. The only caveat here is I do not want the user to be able to delete or drop tables in that database. The standard security (GUI) seems to only allow you to control tables by limiting SELECT, INSERT, UPDATE, DELETE, and DRI.
- Next message: Sandy: "use of application roles"
- Previous message: Jed Ozone: "role/permissions to allow SELECT and creating and deleting triggers"
- In reply to: Jed Ozone: "role/permissions to allow SELECT and creating and deleting triggers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
