??GRANT??????

grant select on temp to usertest with grant option;

???usertest??????temp?????????grant option????????????

??GRANT?????????

grant connect to usertest with admin option;

????usertest??????????????????????

??Oracle Profile

CREATE PROFILE profileLIMIT{     resource_parameters  | password_parameters}

???resource_parameters????SESSIONS_PER_USER?CPU_PER_SESSION????

??????

{    SESSIONS_PER_USER => 10,    CPU_PER_SESSION => 1,    CPU_PER_CALL => 0.5,    CONNECT_TIME => 1??,    IDLE_TIME => 10??,    LOGICAL_READS_PER_SESSION => 100 MB,    LOGICAL_READS_PER_CALL => 10 MB,    COMPOSITE_LIMIT => 200,    PRIVATE_SGA => 100M}

??????

{    FAILED_LOGIN_ATTEMPTS => 3,    PASSWORD_LIFE_TIME => 90?,    PASSWORD_GRACE_TIME => ??,    PASSWORD_REUSE_TIME => 30,    PASSWORD_REUSE_MAX => 10,    PASSWORD_LOCK_TIME => 7?,    PASSWORD_VERIFY_FUNCTION => 'my_verify_function'}

??Session Limits

SESSIONS_PER_USER => 10

?????????????????

??CPU?????

CPU_PER_SESSION => 1,PRIVATE_SGA => 200M

??????

??????

ALTER USER usertest ACCOUNT UNLOCK;

??????

SQL> SHOW USER Privilege;

????????

ALTER USER usertest REVOKE ALL PRIVILEGES;

??????

???????

??????

?????????

CREATE USER usertest IDENTIFIED BY password;GRANT SELECT ON schema.table TO usertest;

??????

ALTER USER usertest CHANGE PASSWORD 'new_password';

??????

DROP PROFILE your_profile_name [CASCADE];