Re: Create User

My first guess would be to look in the forms manual and see if you can perform DCL statements at all. The create user is a DDL command. I will assume that the role has the create_session privilege. I will be pesky also and ask why you (or anyone) are doing this instead of the DBA? Or did you inherit the DBA role also? Oracle Enterprise Manager includes a GUI tool to handle all the user privileges etc.

roy fells <molson_c_at_hotmail.com> wrote in message news:9cmb8101ch0_at_enews4.newsguy.com...
> Hello,
>
> I am fixing some code from the old programmer of the system and he
 has
> a form which is generating an error. I am not sure if this form ever
> functioned right or not but would appreciate if you could tell me why it
> doesn't work, it does the first statement but the subsequent two it
 doesn't,
> when I comment them out it runs fine but I have to go grant the privilages
> myself in sql*plus which is not something I want to have to do. The Admin
> Option wasn't there previously and if I leave it out it says it says it
> can't grant connect without admin option. Thanks for all of your help.
>
> var := execsql('CREATE USER ' || :employee.login_name || ' IDENTIFIED BY
> :password DEFAULT TABLESPACE USR TEMPORARY TABLESPACE TEMPORARY PROFILE
> Default QUOTA UNLIMITED ON INDX QUOTA UNLIMITED ON TEMPORARY QUOTA
 UNLIMITED
> ON USR ACCOUNT UNLOCK');
>
> var := execsql('GRANT CONNECT TO '|| :employee.login_name ||'with ADMIN
> OPTION'); --granting some roles for user
>
> var := execsql('GRANT "PROG_USER" TO "'|| UPPER(:employee.login_name)
||'"')
>
>
Received on Tue May 01 2001 - 12:50:23 CDT