oracle 11g 创建普通用户

 

CREATE USER xiaoming IDENTIFIED by xm123123
GRANT CREATE SESSION TO xiaoming;
GRANT RESOURCE TO xiaoming;
GRANT CONNECT TO xiaoming;

CREATE USER

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_8003.htm#SQLRF01503

DROP USER

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9008.htm

GRANT

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm#i2063861

 

转载于:https://www.cnblogs.com/zno2/p/4887308.html