Quick Search:
 
 Oracle PL/SQL: USER tablespace quota Jump to:  
Category: >> Oracle PL/SQL >> USER tablespace quota  

<< lastnext >>

Snippet Name: USER tablespace quota

Description: Include quota on tablespaces.

Also see:
» USER: connection information
» USER: User Information 2
» USER idle time
» USER Information
» USER active connected users
» USER memory use
» USER: Connected Users
» USER: drop user
» USER: misc queries and commands
» USER system authentication
» USER lock account
» USER password expiration
» USER profile
» USER temp tablespace
» USER tablespace
» USER password
» USERS: view specific user info
» USERS: view currently connected users
» USERS: view all active users
» USERS: Drop users
» USERS: Lock and Unlock accounts
» USERS: Proxy Users
» USERS: Grant tablespace access
» USERS: Alter a user
» USERS: CREATE USER w/ authentication
» USERS: Creating Users
» CREATE USER
» Drop User example
» Create User example
» Create User

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009 

CREATE USER psoug1
IDENTIFIED BY password123
DEFAULT TABLESPACE data
TEMPORARY TABLESPACE temp
QUOTA 0 ON SYSTEM
QUOTA 0 ON SYSAUX
QUOTA UNLIMITED ON data
QUOTA 10M ON data_med;
 
SELECT username, tablespace_name, max_bytes, max_blocks
FROM dba_ts_quotas
ORDER BY 1;
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2025 psoug.org