As system :
--Create application's users profile
--Create user
--Grant Roles,System and Object privellege to user.
CREATE PROFILE app_user LIMIT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL 3000
CONNECT_TIME 45
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL 1000
PRIVATE_SGA 15K
COMPOSITE_LIMIT 5000000;
CREATE USER michael
IDENTIFIED BY michael
DEFAULT TABLESPACE example
QUOTA UNLIMITED ON example
TEMPORARY TABLESPACE temp
PROFILE app_user
PASSWORD EXPIRE;
grant connect,resource to michael;
Ref:
1.
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_8003.htm
2. http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_6010.htm#i2065
As is Apr, 2011
