1.登錄system用戶授權bankuser用戶權限
grant create public synonym to bankuser
2.登錄bankuser，執(zhí)行sql語句
--在bankuser模式下創(chuàng)建公有同義詞public_sy_emp作為bankuser用戶emp表的別名
create public synonym public_sy_emp for emp
--將查詢emp的權限授予public角色
grant select on emp to public
按照性別創(chuàng)建位圖索引
create bitmap index index_bitmap_sex on emp(sex)
