【文件属性】:
文件名称:oracle练习,含答案
文件大小:14KB
文件格式:SQL
更新时间:2022-05-01 10:14:46
plsql
初学oracle的练习题,包含自己做的答案
--1、登陆sys账户的语句。
conn sys/change_on_install@orcl as sysdba;
--2、创建一个新的用户epointtest/123456。
create user epointtest identified by 123456;
--3、更改epointtest的密码为654321。
alter user epointtest identified by 654321;
--4、授予epointtest用户connect和resource的角色权限。
grant connect to epointtest;
grant resource to epoint;
--5、回收epointtest用户的connect权限
revoke connect from epointtest;
--6、删除epointtest用户。
drop user epointtest;