Grant to a user with limited resource privilege

Posted in 2009

Topics: Security, Permissions & Auditing

Krishna — Tue, 2 Jun 2009 02:44:18 -0700 (PDT) — source: Usenet: comp.databases.informix

I would like to provide a user the ability to *only* create stored procedures and views but not tables and indexes. How do I achieve that using the GRANT statement? The resource privilege appears to be an all or nothing proposition. http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqls.doc/ids_sqs_0124.htm Any pointers? Thanks. Krishna

↪ replying to Krishna

Obnoxio The Clown — Tue, 02 Jun 2009 10:52:09 +0100 — source: Usenet: comp.databases.informix

Krishna wrote: > The resource privilege appears to be an all > or nothing proposition. Correct. As far as I know, anyway. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.