假设用户有两个:
website 较高权限
websiteapp 没有创表的权限
表:
在website用户下:
grantselect, insert, update, delete on table_testto websiteapp;
在websiteapp用户下:
--普通用户登录,创建表的同义词
createsynonym websiteapp. table_test
forwebsite. table_test
当然序列也需要设置权限:
website下:
grantselect on seq_mobile_evaluate to websiteapp;//只需赋select权限即可
websiteapp下:
createsynonym websiteapp.seq_mobile_evaluate for website.seq_mobile_evaluate;