[20120813]grant与建立用户.txt

[20120813]grant与建立用户.txt

oracle 下建立用户一般正常的可以使用:
CREATE USER TEST1  IDENTIFIED BY    DEFAULT TABLESPACE USERS   TEMPORARY TABLESPACE TEMP  PROFILE DEFAULT  ACCOUNT UNLOCK;

--并且还要grant一些权限.


而且在做试验或者测试时经常要建立一些用户,这个用户权限可能都是DBA(偷懒)!

实际上grant就可以直接搞定.

1.测试环境:

SQL> select * from v$version ;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE    11.2.0.1.0      Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

2.先删除用户,或者检查这个用户是否存在.

SQL> drop user test1;

User dropped.

SQL> drop user test1;

drop user test1

          *

ERROR at line 1:

ORA-01918: user 'TEST1' does not exist

3.开始操作:

SQL> grant dba to test1 ;

grant dba to test1

             *

ERROR at line 1:

ORA-01917: user or role 'TEST1' does not exist

SQL> grant dba to test1 identified by xxx;

Grant succeeded.

--ok! test1用户建立好.

SQL> connect test1/xxx

Connected.

SQL> show user

USER is "TEST1"

--OK!可以正常使用!