alter user hr account unlock;
alter user hr identified by hr;
--创建用户
create user hr_用户名
identified by hr_用户名;
--赋予权限
grant resource to hr_用户名;
grant connect to hr_用户名;
grant create view to hr_用户名;
hr_abrham001-1.sql
hr_Sample001-2.sql
hr_Sample001-3.sql
alter user hr identified by hr;
--创建用户
create user hr_用户名
identified by hr_用户名;
--赋予权限
grant resource to hr_用户名;
grant connect to hr_用户名;
grant create view to hr_用户名;



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29439655/viewspace-1086070/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29439655/viewspace-1086070/