Home » Developer & Programmer » Forms » Create DBA Through Form
Create DBA Through Form [message #269890] Tue, 25 September 2007 00:47 Go to next message
aslme
Messages: 25
Registered: May 2006
Location: Pakistan
Junior Member

Dear I want to Create user through form
and to create user through SQL command is
grant dba to scott identified by scott;
How can i use this command in when button presssed trigger of a form. or how can i create user without SQL.
Re: Create DBA Through Form [message #269896 is a reply to message #269890] Tue, 25 September 2007 01:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'create user identified by' and you will find http://www.orafaq.com/forum/m/186492/67467/?srch=create+user+identified+by#msg_186492

David
Re: Create DBA Through Form [message #269919 is a reply to message #269896] Tue, 25 September 2007 02:22 Go to previous messageGo to next message
aslme
Messages: 25
Registered: May 2006
Location: Pakistan
Junior Member

But i want to hard coded this line on
when button pressed Trigger
Grant DBA to ABC Identified by ABC
and then connect this user to SQL for writing query.


Cheers
Re: Create DBA Through Form [message #269935 is a reply to message #269919] Tue, 25 September 2007 03:11 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Put similar code into a when-button-pressed trigger. Look at the examples in the reference manual or the help file. Search this forum for 'create user identified by' there are other examples.

What do you mean by "then connect this user to SQL for writing query"? Please be more expansive and give an example.

David
Previous Topic: Problem while retriveing the data of a check box
Next Topic: date problem
Goto Forum:
  


Current Time: Sun Dec 11 08:11:59 CST 2016

Total time taken to generate the page: 0.26564 seconds