创建用户:
create user isc identified by "isc" default tablespace USERS temporary tablespace TEMP profile DEFAULT;
grant connect to isc;
grant dba to isc;
grant resource to isc;
grant unlimited tablespace to isc;
----
更改用户名密码:
alter user isc identified by password
或者:
connect isc/abc123
输入:password
----
删除用户
Connect system/admin
Drop user username;
为用户授予角色
Grant dba to isc;
Grant connect to isc;
亲,沙发正空着,还不快来抢?
我要评论 / 展开表单