create user BWBGDT identified by bwbgdt123;
create role SELECT_ROLE;
grant SELECT ANY DICTIONARY to SELECT_ROLE;
grant SELECT ANY TABLE to SELECT_ROLE;
grant SELECT ANY TRANSACTION to SELECT_ROLE;
grant SELECT ANY SEQUENCE to SELECT_ROLE;
grant connect,resource to bwbgdt;
grant SELECT_ROLE to bwbgdt;
文章评论