USER MANAGEMENT

USER MANAGEMENT:
---------------------------

 USER CREATION:
 ---------------------

  SQL> CREATE USER "DEVELOPER_PROG" PROFILE "DEVELOPER_PROFILE" IDENTIFIED BY "SURENDRA" DEFAULT TABLESPACE "USERS"         TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;

  SQL> GRANT "DEVELOPER_ROLE" TO "DEVELOPER_PROG";


 USER CREATION WITH EXTERNAL PASSWORD:
 -------------------------------------

  SQL> CREATE USER "DEVELOPER_PROG" PROFILE "DEVELOPER_PROFILE" IDENTIFIED EXTERNALLY DEFAULT TABLESPACE "USERS"         TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
 
  SQL> GRANT "DEVELOPER_ROLE" TO "DEVELOPER_PROG";



  SQL> ALTER USER "DEVELOPER_PROG" ACCOUNT LOCK;



 PROFILE CREATION :
 ------------------

  SQL> CREATE PROFILE "DEVELOPER_PROFILE" LIMIT CPU_PER_SESSION 36000
    CPU_PER_CALL 1000
    CONNECT_TIME 120
    IDLE_TIME 15
    SESSIONS_PER_USER 10
    LOGICAL_READS_PER_SESSION 5000
    LOGICAL_READS_PER_CALL 1000
    PRIVATE_SGA DEFAULT
    COMPOSITE_LIMIT 5000000
    PASSWORD_LIFE_TIME 120
    PASSWORD_GRACE_TIME 7
    PASSWORD_REUSE_MAX 10
    PASSWORD_REUSE_TIME UNLIMITED
    PASSWORD_LOCK_TIME 1
    FAILED_LOGIN_ATTEMPTS 3
    PASSWORD_VERIFY_FUNCTION NULL;

 ALTER PROFILES:
 ---------------

  SQL> ALTER PROFILE "DEVELOPER_PROFILE" LIMIT CPU_PER_CALL 6000;

  SQL> ALTER PROFILE "DEVELOPER_PROFILE" LIMIT CPU_PER_CALL 6000
    PRIVATE_SGA 256K;




REOLES:
-------

  CREATING ROLES:
  --------------
  
     SQL>CREATE ROLE "DEVELOPER_ROLE" NOT IDENTIFIED;

    SQL>GRANT CREATE CLUSTER TO "DEVELOPER_ROLE";

    SQL>GRANT CREATE SEQUENCE TO "DEVELOPER_ROLE";

    SQL>GRANT CREATE SESSION TO "DEVELOPER_ROLE";

    SQL>GRANT CREATE TABLE TO "DEVELOPER_ROLE";

    SQL>GRANT CREATE TYPE TO "DEVELOPER_ROLE";

    SQL>GRANT CREATE VIEW TO "DEVELOPER_ROLE";

    SQL>GRANT "CONNECT" TO "DEVELOPER_ROLE;

  ALTERIGN ROLES:
  ---------------

        SQL> REVOKE CREATE VIEW FROM "DEVELOPER_ROLE";