Revoke Privileges from a role

From: <webbde_at_post.queensu.ca>
Date: Thu, 27 May 1999 16:10:24 GMT
Message-ID: <7ijqpe$s9t$1_at_nnrp1.deja.com>



Hi,

How do I go about revoking specific object privileges from a role from my Forms 5.0 application? Specifically, I have a small app that processes casual staff timecards. My users are assigned a role "tc_user" that has the select, insert, update, and delete privileges on the timecard table. At a certain time, I would like the database administrator to sign on as the schema owner and close the [Quoted] [Quoted] timecard table to updates or, essentially, be able to click on a button that would issue the command ...

"revoke insert, update, delete ON timecard from tc_user; commit;"

In theory, I hope this would allow tc_user to continue to select on the [Quoted] table untill the schema owner re assigns the other privileges. I'm trying to avoid having the clerk, who will be acting as the database administrator, go into SQL*Plus and issue the revoke command.

Any ideas would be greatly appreciated.

Thanks
Dan Webb
webbde_at_post.queensu.ca

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 27 1999 - 18:10:24 CEST

Original text of this message