Hi All,
SQL Server 2012 SP1 - Windows 2008 R2
I have a database user where I gave it db_datareader, db_datawriter, db_ddladmin and db_securityadmin permissions. When the user ran below quey, she got
The EXECUTE permission was denied on the object 'TableExists', database 'MyTESTDB', schema 'dbo'. Error.
-- Query:
IF dbo.TableExists('sco_runtime_error_log') = 'T'
BEGIN
DROP TABLE sco_runtime_error_log;
END
GO
Can anyone tell me why ?
Thanks.