已经拥有connect,resource 权限,但不能建立函数索引
提示如下:
create index ix_test_abc on test_abc(substr(astr,5));
ORA-01031: insufficient privileges
通过显式授权,grant query rewrite to username解决
已经拥有connect,resource 权限,但不能建立函数索引
提示如下:
create index ix_test_abc on test_abc(substr(astr,5));
ORA-01031: insufficient privileges
通过显式授权,grant query rewrite to username解决