Re: acccessing the sample database on oracle 10g

Nospam wrote:
> I have installed oracle 10g on red hat linu 9. I am wondering what I type
> to access the sample dataase scott/tiger v$ession. what do I type after
>
> sysdba /nolog
>
> to access and manipulate the sample databases?
>
> thanks

In so short a pragraph evidence a number of misunderstandings

1. v$session is not part of the scott schema and is not sample data
2. v$session is a synonym for v_$session which is a magic view owned by SYS
3. v$session can not be accessed by scott unless the specific access privilege is granted by SYS

SQL> conn / as sysdba
SQL> GRANT SELECT ON v_$session TO scott;
SQL> conn scott/tiger
SQL> SELECT * FROM v$session;

If you want to view information about the scott user logging on as SYS then:

SQL> conn / as sysdba
SQL> SELECT * FROM v$session WHERE username = 'SCOTT';

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)