创建账号并给予某个表的权限
创建账号:
CREATE USER [用户名] IDENTIFIED BY [密码]; GRANT CREATE SESSION TO username; GRANT SELECT, INSERT, UPDATE, DELETE ON [表名] TO [用户名];
删除账号:
drop user test_user;
正在加载评论...
CREATE USER [用户名] IDENTIFIED BY [密码]; GRANT CREATE SESSION TO username; GRANT SELECT, INSERT, UPDATE, DELETE ON [表名] TO [用户名];
drop user test_user;