2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
This was a user rights issue : 1°) SQL Server username needs to have usermapping with db_datareader & public on SQL Server database 2°) SQL Server username used by Lambda function should be able to read in table : SYS.DM_DB_PARTITION_STATS :
USE [database_name];
GRANT VIEW DATABASE STATE TO [user_name];
3°) maque sure that schema to be read (ex : "dbo") has issqluser column value at "1" in table : sys.sysusers
répondu il y a un an
0
it may be related with the JDBC Driver you are using or the Connection String try to write queries like database.schema.tablename for SQL Server like database.dbo.tbl_name
Contenus pertinents
- demandé il y a 2 mois
- Réponse acceptéedemandé il y a un an
- demandé il y a 7 mois
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 3 mois
Ni Sedat, just a SQL server user rights issue.