Re: Table permissions
From: Uri Dimant (urid_at_iscar.co.il)
Date: 02/02/05
- Next message: Lito Dominguez: "linked server suddenly doesn't work!!!"
- Previous message: Eric D.: "Table permissions"
- In reply to: Eric D.: "Table permissions"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Feb 2005 18:12:00 +0200
Eric
This script was written by Aaron Bertrand
This will only cover those who have
been explicitly given access to the procs using GRANT.
DECLARE @username VARCHAR(32)
SELECT @username = '???'
SELECT o.name, CanExec = CASE WHEN p.id = o.id THEN 'Yes' ELSE 'No' END
FROM sysobjects o LEFT OUTER JOIN syspermissions p
ON o.id = p.id
AND p.grantee = USER_ID(@username)
"Eric D." <Eric D.@discussions.microsoft.com> wrote in message
news:A09ABB02-184C-4C0A-B920-00F4531D0B84@microsoft.com...
> Hi,
>
> I'm trying to display permissions to a specific table for a particular
> individual. How would I go about doing so. I'm pretty sure it has to do
with
> information_schema, but that's as far as I can go.
>
> TIA
- Next message: Lito Dominguez: "linked server suddenly doesn't work!!!"
- Previous message: Eric D.: "Table permissions"
- In reply to: Eric D.: "Table permissions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
