| difference between normal and 'as sysdba' [message #180905] |
Wed, 05 July 2006 15:23  |
macquivr
Messages: 10
Registered: June 2006
|
Junior Member |
|
|
I created a user myuser
default tablespace 'SYSTEM' <== (this might be my problem)
said 'grant SYSDBA to myuser'
when I say sqplus myuser/mypass
sqlplus> select username from dba_users;
I get '00942: table of view does not exist'
but when I say sqplus myuser/mypass as sysdba
sqlplus> select username from dba_users;
<it works>
This problem extends to tables like DBA_TABLESPACES, blah blah blah, but
I'm sure its all the same problem.
What do I have to do to get sqlplus to see the right stuff without having to connect 'as sysdba'?
- John
|
|
|
|
|
|
|
|
|
|
| Re: difference between normal and 'as sysdba' [message #180982 is a reply to message #180907] |
Thu, 06 July 2006 02:56  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
One of the 'rules' of this (and just about any other it forum) is not to cross post. Most of the people who can answer your question will check through most of the forums for new threads that they can/are willing to answer. To re-iterate, please do not cross post (It's one of the things mentioned in the sticky at the top of the forum)
The difference between 'normal' and 'as sysdba' is a huge one. When you log on as sysdba you are logging on as the sys user not as the 'normal' user:
Try
conn usernameWithSysDbaPrivs/password@db as sysdba
then show user
it will output
SYS
the sys user has far far higher level of priviledges than any other user.
when you log on as your normal user, you don't have the appropriate priviledgs to access the DBA_ tables.
HTH
Jim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
