Login as SYS [message #552166] |
Tue, 24 April 2012 01:33 |
|
new_oracle2011
Messages: 174 Registered: March 2011 Location: Qatar
|
Senior Member |
|
|
is it possible to login as SYSDBA in oracle forms from normal logon procedure?
logon(sys_acc, sys_pwd||'@'||:GLOBAL.db_conn);
The reason behind this is to make a form which will alter user's password. But all the users are in SYS account and it is necessary to login as SYSDBA in forms to execute alter statement.
Or is there another way of doing this then do let me know.
|
|
|
|
|
|
Re: Login as SYS [message #552365 is a reply to message #552199] |
Wed, 25 April 2012 04:33 |
|
zh_lin
Messages: 1 Registered: April 2012 Location: Shanghai China
|
Junior Member |
|
|
I have met the same problem. there is still some job like 'grant select on sys.dba_role_privs to user' can only be done by sys. firstly, i want to resolve it with logon as sysdba, but oracle form reject such method. after one week hard investigation, i do it in forms builder as following scripts, wish it is helpful.
host('/bin/printf "grant select on sys.dba_role_privs to user';
exit; " | /oraclehome directory/bin/sqlplus -s "sys/sys@tnsname as sysdba" ',no_screen);
[Updated on: Wed, 25 April 2012 04:35] Report message to a moderator
|
|
|