RE: dbms_sys_sql

I have used it to write an installer for database objects (used dbms_sys_sql to add the proper grants to another user's objects). Worked without issue. The parameters were all the same except the added parameter on parse_as_user.

Just be careful about who you grant access to the package. Any user with execute permission on the package has an implied SYS logon.

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600

-----Original Message-----
Sent: Friday, May 18, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L

Anyone using dbms_sys_sql? It does what I want but I can't find any documentation on it. It's not in the PL/SQL Packages Reference manual.
(I'd RTFM if I could just find one to read!) What I can find seems to
indicate that dbms_sql uses dbms_sys_sql. So I would assume it's a stable, if undocumented package. Any insight?

TIA! Linda

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seley, Linda
  INET: LSeley_at_IQNavigator.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_at_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Norrell, Brian
  INET: BNorrell_at_QuadraMed.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_at_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).