kods.net » oracle,sql statement,error message » Oracle access to the current user's default tablespace

Oracle access to the current user's default tablespace

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:

Oracle access to the current user's default tablespace

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

Digg Technorati StumbleUpon Mixx del.icio.us Reddit BlinkList Furl YahooMyWeb

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/

Leave a reply