Re: Export user DDL and privileges?

From: Tim Hall <tim_at_oracle-base.com>
Date: Fri, 27 Jul 2012 18:25:24 +0100
Message-ID: <CAP=5zEhJwdKgfHtUm=LP+F7MWube-XppknU7PyRb7RUgxBFmFg_at_mail.gmail.com>

You scared me so I did a little test. The lack of a tablespace quota doesn't affect it as far as I can see. Am I missing something?

• Test Start ***** SQL> create user tim_test identified by tim_test; SQL> _at_user_ddl tim_test

   CREATE USER "TIM_TEST" IDENTIFIED BY VALUES 'S:37C67A87A9F9D6D777A99268155EF5 47FA22597519A952F8A2803C03C8EB;845E983CCC9EE9A6'       TEMPORARY TABLESPACE "TEMP"; SQL> grant create session to tim_test;
SQL> _at_user_ddl tim_test

   CREATE USER "TIM_TEST" IDENTIFIED BY VALUES 'S:37C67A87A9F9D6D777A99268155EF5 47FA22597519A952F8A2803C03C8EB;845E983CCC9EE9A6'       TEMPORARY TABLESPACE "TEMP";   GRANT CREATE SESSION TO "TIM_TEST"; SQL> alter user tim_test profile testdev; SQL> _at_user_ddl tim_test

   CREATE USER "TIM_TEST" IDENTIFIED BY VALUES 'S:37C67A87A9F9D6D777A99268155EF5 47FA22597519A952F8A2803C03C8EB;845E983CCC9EE9A6'

      TEMPORARY TABLESPACE "TEMP"
      PROFILE "TESTDEV";

  GRANT CREATE SESSION TO "TIM_TEST";    CREATE PROFILE "TESTDEV"
    LIMIT

         COMPOSITE_LIMIT DEFAULT
         SESSIONS_PER_USER DEFAULT
         CPU_PER_SESSION DEFAULT
         CPU_PER_CALL DEFAULT
         LOGICAL_READS_PER_SESSION DEFAULT
         LOGICAL_READS_PER_CALL DEFAULT
         IDLE_TIME DEFAULT
         CONNECT_TIME DEFAULT
         PRIVATE_SGA DEFAULT
         FAILED_LOGIN_ATTEMPTS 6
         PASSWORD_LIFE_TIME DEFAULT
         PASSWORD_REUSE_TIME DEFAULT
         PASSWORD_REUSE_MAX DEFAULT
         PASSWORD_VERIFY_FUNCTION DEFAULT
         PASSWORD_LOCK_TIME DEFAULT
         PASSWORD_GRACE_TIME DEFAULT ;

SQL>
***** Test End *****

Cheers

Tim...

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 27 2012 - 12:25:24 CDT