G gacar Active Member Oct 23, 2021 #1 Is it posible using MSSQL Views with JdbcResultSet and how? I couldn't get value. Code: Dim rsTable As JdbcResultSet = SQL.execquery("select * FROM DataTable") '<=== Here success from Table Dim rsView As JdbcResultSet = SQL.execquery("select * FROM DataView") '<=== Here not success from Views. Stopping app without error.
Is it posible using MSSQL Views with JdbcResultSet and how? I couldn't get value. Code: Dim rsTable As JdbcResultSet = SQL.execquery("select * FROM DataTable") '<=== Here success from Table Dim rsView As JdbcResultSet = SQL.execquery("select * FROM DataView") '<=== Here not success from Views. Stopping app without error.
Solution G G gacar Oct 23, 2021 I found solution here https://support.oneidentity.com/kb/...-was-denied-on-object-server-database-master- Run this command in MSSMS Code: GRANT VIEW SERVER STATE TO "UserName"
I found solution here https://support.oneidentity.com/kb/...-was-denied-on-object-server-database-master- Run this command in MSSMS Code: GRANT VIEW SERVER STATE TO "UserName"
G gacar Active Member Oct 23, 2021 #2 I found solution here https://support.oneidentity.com/kb/...-was-denied-on-object-server-database-master- Run this command in MSSMS Code: GRANT VIEW SERVER STATE TO "UserName" Upvote 0 Solution
I found solution here https://support.oneidentity.com/kb/...-was-denied-on-object-server-database-master- Run this command in MSSMS Code: GRANT VIEW SERVER STATE TO "UserName"
