[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!可以正常使用!

ITPub博客

[20120813]grant与建立用户.txt

最新文章