SQL errors in Logs / permission was denied

[becksen]

Hi all,

in the AS Logs I can see several errors but I don't know where they come from and how to solve it.

Is it only a permission issue on the MSSQL Server 2012 DB?

Thanks for your support.

#2.0 #2016 05 09 13:11:38:449#+0200#Info#/System/Database/Jddic/Database#

###C0000A643FDA000300000004000003F4#5317650000002138##com.sap.dictionary.database.mss.DbMssTable####A6CCC71915D611E6957F005056A37908#a6ccc71915d611e6957f005056a37908#a6ccc71915d611e6957f005056a37908#0#Service Runner [com.sap.tc.pcd.gl.srv]#Plain#com.sap.dictionary.database.dbs.messages.messages#

table BC_EXTRA_RULES doesn't exist on db#

#2.0 #2016 05 09 14:47:27:946#+0200#Error#/System/Database/sql/jdbc/direct#

com.sap.sql_0003#BC-JAS-PER-SQL#opensqlkernel#C0000A643FDA003F00000000000003F4#5317650000013227##com.sap.sql.jdbc.direct.DirectStatement####A6CCC71B15D611E6A821005056A37908#a6ccc71b15d611e6a821005056a37908#a6ccc71b15d611e6a821005056a37908#0#Timeout Event Processor, id [153], invocation [0]#Plain#com.sap.sql.log.OpenSQLResourceBundle#

SQL error occurred on connection DEIDM1:MXMC_db:MXMC_admin_u: code={0,number,integer}, state="S0005", message="The SELECT permission was denied on the object 'MXWV_dbschema', database 'MXMC_db', schema 'dbo'.";

SQL statement is "select max(versionnum) as schemaversion from MXWV_dbschema".#

[jaisuryan · Accepted solution]

Hi Timmy,

What user have you used for JDBC connection in AS JAVA?

Change to MXMC_PROV and check if the logs are appearing.

Kind regards,

Jai

[becksen · Accepted solution]

Hi Jai,

in the JDBC connection MXMC_admin is set on AS JAVA.

I've changed it to MXMC_prov and it works fine.

Thanks a lot for your excellent help!

Best regards Timmy.