role/permissions to allow SELECT and creating and deleting triggers
From: Jed Ozone (ozone_at_yahoo.com)
Date: 06/26/03
- Next message: Tom Moreau: "Re: role/permissions to allow SELECT and creating and deleting triggers"
- Previous message: Angela Henry: "Locking down jobs in SQL Agent"
- Next in thread: Tom Moreau: "Re: role/permissions to allow SELECT and creating and deleting triggers"
- Reply: Tom Moreau: "Re: role/permissions to allow SELECT and creating and deleting triggers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 26 Jun 2003 15:58:49 -0400
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: Tom Moreau: "Re: role/permissions to allow SELECT and creating and deleting triggers"
- Previous message: Angela Henry: "Locking down jobs in SQL Agent"
- Next in thread: Tom Moreau: "Re: role/permissions to allow SELECT and creating and deleting triggers"
- Reply: Tom Moreau: "Re: role/permissions to allow SELECT and creating and deleting triggers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
