OraFAQ Forum: Forms » Creating user usnig forms

Home » Developer & Programmer » Forms » Creating user usnig forms_DDL (forms developer 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating user usnig forms_DDL [message #277524]

Tue, 30 October 2007 07:51

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

Report message to a moderator

Re: Creating user usnig forms_DDL [message #277531 is a reply to message #277524]

Tue, 30 October 2007 08:08

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

Report message to a moderator

Re: Creating user usnig forms_DDL [message #277683 is a reply to message #277531]

Wed, 31 October 2007 03:14

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

Report message to a moderator

Re: Creating user usnig forms_DDL [message #277814 is a reply to message #277683]

Wed, 31 October 2007 14:34

Littlefoot
Messages: 21823
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!

Report message to a moderator

Re: Creating user usnig forms_DDL [message #277983 is a reply to message #277814]

Thu, 01 November 2007 06:39

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

thanks brother
every thing is ok

Report message to a moderator

Previous Topic:	when - tree - node -select
Next Topic:	LOV for the dba_users

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 14:31:54 CDT 2025