Hello, SQL 2008 R2
We are changing our level of PCI certification and I have a question about SQL access security.
Is there a way to give someone (windows active directory logon) access to execute a stored procedure without giving them access to read and write to the database? I was thinking of the stored procedure doing a run as, thus the user cannot directly edit the database.
Thanks
djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!
We are changing our level of PCI certification and I have a question about SQL access security.
Is there a way to give someone (windows active directory logon) access to execute a stored procedure without giving them access to read and write to the database? I was thinking of the stored procedure doing a run as, thus the user cannot directly edit the database.
Thanks
djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!