Oracle access to the current user's default tablespace

Posted on 2009-06-23 filed under: Oracle (RSS) 27 views   

Many people use the Internet select default_tablespace from dba_users where usename = 'User name'; this SQL statement, but in fact is not easy to use, because when the current user does not have read permissions dba_users when an error, an error message is as follows:



If you use select username, default_tablespace from user_users; the SQL statement just fine.

Tags: oracle oracle, sql statement, error message, current user

Permalink: http://www.kods.netwww.kods.net/oracle-access-to-the-current-user-s-default-tablespace/