It seems at times when roles are assigned they are not assigned as DEFAULT role to a user. The reason for seems to be the following: In the table sys.user$ there is a column called "DEFROLE" which indicates if the role will be a default role or not. The possible values that seem to be … Continue reading DEFAULT role explained
Tag: DEFAULT
How to find users with default password in 11g?
Now Oracle has a quick way to find users with detault password. SQL> SELECT * FROM dba_users_with_defpwd; And here is the output: USERNAME ------------------------------ DIP MDSYS WK_TEST CTXSYS OLAPSYS OUTLN EXFSYS SCOTT MDDATA ORDPLUGINS ORDSYS XDB LBACSYS SI_INFORMTN_SCHEMA WMSYS
Oracle Created (Default) Database Users
List of oracle default users and their password. After creating the database one may want to change the password for these users or lock the account if the feature is not being used. http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_26.shtml
How to set/find default tablespace in 10g?
-- Set default tablespace for all users, so when users are created without specifying default tablespace it will be user's default tablespace SQL> ALTER DATABASE DEFAULT TABLESPACE abc; Database altered. -- To find the default tablespace name for the database is SQL> SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME = 'DEFAULT_PERMANENT_TABLESPACE'; PROPERTY_VALUE ------------------ ABC Once when … Continue reading How to set/find default tablespace in 10g?