catch.saravana
Member
Version: 11.6
OS: Linux CentOS7
I created couple of users and grant permission for few tables using sqlexp. How do I check if the privileges are set properly? I tried querying 'USER_TAB_PRIVS' view but it threw error saying;
=== SQL Exception 1 ===
SQLState=42S02
ErrorCode=-210083
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/view/synonynm "SYSPROGRESS.USER_TAB_PRIVS" cannot be found. (15814)
OS: Linux CentOS7
I created couple of users and grant permission for few tables using sqlexp. How do I check if the privileges are set properly? I tried querying 'USER_TAB_PRIVS' view but it threw error saying;
=== SQL Exception 1 ===
SQLState=42S02
ErrorCode=-210083
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/view/synonynm "SYSPROGRESS.USER_TAB_PRIVS" cannot be found. (15814)