From carmichr@hotmail.com Mon, 17 Sep 2001 19:27:53 -0700 From: "Rachel Carmichael" Date: Mon, 17 Sep 2001 19:27:53 -0700 Subject: Re: Alternatives to roles in procedures? Message-ID: MIME-Version: 1.0 Content-Type: text/plain um, create the procedures in schema A and grant execute to schema B? removes the need for direct grants on the tables. >From: "Jesse, Rich" >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: Alternatives to roles in procedures? >Date: Mon, 17 Sep 2001 12:30:24 -0800 > >So, there we are, in 8.1.7 on HP/UX 11.0. We have several dozen tables in >schema "A" that need to be accessed from procedures in schema "B". We had >previously been using a role to grant access to these tables but now with >the procedures, this ain't an option. > >Are there any alternatives to granting SELECT, INSERT, UPDATE, DELETE, etc >on each table to schema "B"? > >TIA, >Rich Jesse System/Database Administrator >Rich.Jesse@qtiworld.com Quad/Tech International, Sussex, WI USA >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jesse, Rich > INET: Rich.Jesse@qtiworld.com > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).