创建用户
--创建用户名字是ENS_UPRIGHT 密码是ENS_UPRIGHT
create user ENS_UPRIGHT identified by ENS_UPRIGHT;
赋予连接权限
--给用户ENS_UPRIGHT赋予连接权限
grant connect, resource to ENS_UPRIGHT;
赋予表的权限
--给用户ENS_UPRIGHT赋予创建表的权限
grant create any table to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予drop表的权限
grant drop any table to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予修改表的权限
grant alter any table to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予查询表的权限
grant select any table to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予插入数据的权限
grant insert any table to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予删除数据的权限
grant delete any table to ENS_UPRIGHT;
赋予序列权限
--给用户ENS_UPRIGHT赋予创建序列的权限
grant create any sequence to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予删除序列的权限
grant drop any sequence to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予修改序列的权限
grant alter any sequence to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予查询序列的权限
grant select any sequence to ENS_UPRIGHT;
赋予索引权限
--给用户ENS_UPRIGHT赋予创建索引的权限
grant create any index to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予删除索引的权限
grant drop any index to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予修改索引的权限
grant alter any index to ENS_UPRIGHT;
赋予PLSQL的权限
--给用户ENS_UPRIGHT赋予创建PLSQL的权限
grant create any procedure to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予执行PLSQ的权限
grant execute any procedure to ENS_UPRIGHT;
--给用户ENS_UPRIGHT赋予修改PLSQ的权限
grant alter any procedure to ENS_UPRIGHT;