I am using SQL Server 2008. Where are the revoked permissions stored in the database? I found the grant permissions in sys.database_permissions table. But the permissions are still there for a stored procedure in sys.database_permissions even after I removed it using revoke EXECUTE ON StoredProcedure to USER
Where can see all the revoked permissions for a Stored Procedure or Function ?