Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Create User
The reason I am doing this is because I inherited the DBA Role as well The DDL command works and talking to my boss the form has been used in the past and worked fine (though with the errors I am getting the last guys either altered the code and noone knew or the code has never really been used and it is a communication problem. Thanks for the tip on the Oracle Enterprse Manager
>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.
>
>
>> 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 - 13:40:15 CDT