Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Questions about PL/Sql stored procedures

Questions about PL/Sql stored procedures

From: <chrisoc_at_iclick.com>
Date: Sun, 24 Sep 2000 01:33:55 GMT
Message-ID: <8qjlm3$7b1$1@nnrp1.deja.com> 








Is it possible for a stored procedure to tell  who
has called it?



Is it possible for a stored procedure that is run by
a user with DBA privileges  to create  a user, set
a password and some basic privileges for that user,
and then connect as that user and do some more  DDL
and DML? Or would that second connection  have to
be done  from "outside", say in a SQL*Plus procedure?



Chris O'Connor




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Sat Sep 23 2000 - 20:33:55 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US