Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Permissions on v$parameter

557564Jan 22 2007 — edited Jan 22 2007
Hello.

I'm trying to debug a problem that our QA department found. I think the bug lies in their NLS_ settings. When I tried to login as the oracle user that found the bug, I do a:

sql> show parameter NLS;

but the command complains about view/table not found. When I describe v$parameter, the table doesn't show up. When I log in as sys, but show and describe commands work.

Now, since I'm not a DBA, my question is, shouldn't all users have read access to v$parameter? If not, what is the command to show what is set for your session? I always thought it was show parameter...

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2007
Added on Jan 22 2007
3 comments
1,393 views