OraFAQ Forum: Forms » Create DBA Through Form

Home » Developer & Programmer » Forms » Create DBA Through Form

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

Create DBA Through Form [message #269890]

Tue, 25 September 2007 00:47

aslme
Messages: 26
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.

Report message to a moderator

Re: Create DBA Through Form [message #269896 is a reply to message #269890]

Tue, 25 September 2007 01:29

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Create DBA Through Form [message #269919 is a reply to message #269896]

Tue, 25 September 2007 02:22

aslme
Messages: 26
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

Report message to a moderator

Re: Create DBA Through Form [message #269935 is a reply to message #269919]

Tue, 25 September 2007 03:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 06:23:57 CST 2024