Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> user mgmt (grants etc) via stored procedures
Is it possible to create roles, grants, revokes, create users, etc within stored procedures?
I want to be able to do this but it doesnt take the create:
create or replace procedure create_user (uname varchar2) as begin
DBMS_OUTPUT.PUT_LINE('creating user:' ||uname); create user uname identified by uname;
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Jun 07 2000 - 00:00:00 CDT