实例HR用户对象创建
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_用户名;
hr_abrham001-1.sqlhr_Sample001-2.sqlhr_Sample001-3.sql来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29439655/viewspace-1086070/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
