Home » Developer & Programmer » Forms » Creating user usnig forms_DDL (forms developer 6i)
Creating user usnig forms_DDL [message #277524] Tue, 30 October 2007 07:51 Go to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
Dear all
This is my first participation so i hope we can help each other in the best way
I want to create a user and give him privilages and on a tablespace called "test" that i have created befor

usnig PL/SQL forms_ddl
and best wishes for all
Re: Creating user usnig forms_DDL [message #277531 is a reply to message #277524] Tue, 30 October 2007 08:08 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Here is how you create a user.

Why do you want to do it via Forms rather than through (say) Sql*Plus
Re: Creating user usnig forms_DDL [message #277683 is a reply to message #277531] Wed, 31 October 2007 03:14 Go to previous messageGo to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
Thanks friend for ur cooperation
but i havnt see any way to create a user using FORMS_DDL

i will be so pleasure if u can help me
best wishes

Re: Creating user usnig forms_DDL [message #277814 is a reply to message #277683] Wed, 31 October 2007 14:34 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I've created a sample form with only one push button; WHEN-BUTTON-PRESSED trigger looks like this (in its simplest form, just to create a user, let it connect and - depending on database version - do even something else):
forms_ddl('create user brisime identified by x');
forms_ddl('grant connect, resource to brisime');
SQL*Plus session looks like this:
SQL> -- before pushing a form button
SQL> connect brisime/x@ora10lp
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> -- after pushing a form button
SQL> connect brisime/x@ora10lp
Connected.
As you can see, user 'brisime' successfully connected to the database.

Now, what did you do (or didn't do) so that it didn't work? Lucky guess: did you connect as a privileged user while running a form? Not everyone can create users and grant privileges!
Re: Creating user usnig forms_DDL [message #277983 is a reply to message #277814] Thu, 01 November 2007 06:39 Go to previous message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
thanks brother
every thing is ok
Previous Topic: when - tree - node -select
Next Topic: LOV for the dba_users
Goto Forum:
  


Current Time: Fri Dec 02 14:26:35 CST 2016

Total time taken to generate the page: 0.09384 seconds