Oracle

JAVA学习网 2018-03-30 22:09:01

1.创建用户

  create user user_name identified by user_password;

2.赋予权限

赋予查询权限

  grant select on table_name to username

赋予更新权限

  grant update on table_name to username

赋予插入权限

  grant insert on table_name to username  

赋予删除权限

  grant delete on table_name to username

阅读(730) 评论(0)