This enables a application login with low privileges to perform owner (dbo) privileged functionality using just the execute permissions on the sproc.
CREATE PROCEDURE dbo.EmptyMyTable
WITH EXECUTE AS OWNER
AS
BEGIN
TRUNCATE dbo.TableA
END
Clay Lenhart : SQL Server Security with EXECUTE AS OWNER
No comments:
Post a Comment