What is your DB Version.....

Have u Given Privs to the User...


SQL> SELECT * FROM v$SESSION WHERE AUDSID = (select
sys_context('USERENV','SESSIONID') from dual);

SADDR SID SERIAL# AUDSID PADDR USER# USERNAME
COMMAND OWNERID TADDR LOCKWAIT STATUS
-------- ---------- ---------- ---------- -------- ----------
------------------------------ ---------- ---------- -------- --------
--------
08B0C020 12 18487 178 08AF92F4 18 SCOTT
3 2147483644 ACTIVE


HTH

Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019
Oracle LazyDBA home page