很明显没有权限, 最简单的解决办法,直接右键你要操作的表(存储过程啥的),赋值权限就好了
the execute permission was denied on then object 'sp_OACreate',database 'mssqlsystemresource',schema 'sys' 给sql 相应的账号添加sysadmin角色
The EXECUTE permission was denied on the object 'GetEmployees', database 'MyDatabase', schema 'dbo'. 1. 2. 这个错误消息表示我们没有足够的权限来执行存储过程。为了解决这个问题,我们需要确保在创建存储过程时,当前用户具有足够的权限来执行该存储过程。可以通过授予EXECUTE权限给当前用户,或者将存储过程所属...
the execute permission was denied on then object 'sp_OACreate',database 'mssqlsystemresource',schema 'sys' 给sql 相应的账号添加sysadmin角色
Quick BI建数据集报错“SQL execute error by datasource... org.postgresql.util.PSQLException: ERROR: permission denied for foreign table XXX”。 问题原因 一般出现“SQL execute error by datasource... ”字样,需要排查数据源侧的原因。本问题是没有外表权限导致。
EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb', schema 'dbo'. 若要傳送 Database Mail,使用者必須是 msdb 資料庫中的使用者,且為 msdb 資料庫中 DatabaseMailUserRole 資料庫角色的成員。 若要將 msdb 使用者或群組新增至此角色,請使用 SQL Server Management Studio 或對需要傳送...
EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb', schema 'dbo'. 要发送数据库邮件,用户必须是 msdb 数据库中的用户,并且是 msdb 数据库中的 DatabaseMailUserRole 数据库角色的成员。 要将 msdb 用户或组添加到此角色中,请使用 SQL Server Management Studio 或对需要发送数据库邮件...
Failed to execute IS server package because of error 0x80131904. Server:SERVER NAME, Package path: \SSISDB\Folder\Package.dtsx, Environment reference Id: NULL. Description: The EXECUTE permission was denied on the object 'xp_regread', database 'mssqlsystemresource', schema 'sys'....
"The EXECUTE permission was denied on the object 'sp_enable_sql_debug'... ##MS_DatabaseMasterKey## on user database A call to 'CreateProcessAsUser' failed with error code: '1314'. A connection was successfully established with the server, but then an error occurred during the pre-login...
When I am trying to access the SSSM, it throwing an error like ‘EXECUTE permission was denied on the object 'xp_instance_regread', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) ‘. We know it’s knew error with past SQL versions and we used to gra...