-
Folks,
Context
---------
Using Oracle9i, I have a program Pro*C program that connects as SYSTEM user. Then, it proceeds to create another userid and give it various priveleges. I also need to give the new userid SELECT privileges on tables owned by SYS.
Solution
---------
In order to GRANT SELECT to the SYS tables, my program does the following:
EXEC SQL CONNECT :system_uid
IDENTIFIED BY :system_pwd
USING :local_db IN SYSDBA MODE ;
Problem
---------
This solution worked on the NT 2000 platform running Oracle 9.0.1.3. However, on the Sun platform, this same piece of code returns ORA-1031 (insufficient priveleges).
Why this disparity?
Please help.
Thanks,
Dan
-
Hi
Try to connect as "system/manager as sysdba" if you want to connect as SYS.
So type -- as dba at your system_pwd
For eg:
sui: system
sys_pwd: manager as sysdba
This may work....
Folks, Correct me if i'm wrong.
Thanks
PNRDBA
-
I think you are trying to give select privileges being in system, to another user. ORA 1031 says--
When you try to give privileges to another user which has got highier label than the connected one, then definitely it won't allow. Try connecting as sysdba, and then give select privileges.
Thanks.
PNRDBA
-
You should be sys to grant privs on sys.tables.
Thanks.
Thanigaivasan.
-
Check this....
$oerr ora 1031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary operating
// system privileges.
// When Trusted Oracle is configure in DBMS MAC, this error may occur
// if the user was granted the necessary privilege at a higher label
// than the current login.
// *Action: Ask the database administrator to perform the operation or grant
// the required privileges.
// For Trusted Oracle users getting this error although granted the
// the appropriate privilege at a higher label, ask the database
// administrator to regrant the privilege at the appropriate label.
Thanks.
Thanigaivasan.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|