At the risk of stating the obvious, you may need to precede the
statement Mike mentions by
USE databaseName
where you substitute the name of the database for "databaseName".
Andrew Watt
MVP - InfoPath
On Wed, 20 Apr 2005 21:22:55 +0200, "Mike Epprecht \(SQL MVP\)"
[quoted text, click to view] <mike@epprecht.net> wrote:
>Hi
>
>Look at sp_helprotect in Books Online.
>
>e.g.
>This example lists the permissions for the titles table.
>
>EXEC sp_helprotect 'titles'
>Regards
>--------------------------------
>Mike Epprecht, Microsoft SQL Server MVP
>Zurich, Switzerland
>
>IM: mike@epprecht.net
>
>MVP Program:
http://www.microsoft.com/mvp >
>Blog:
http://www.msmvps.com/epprecht/ >
>"foobar" <esuey@inbizservices.com> wrote in message
>news:u5$UmjcRFHA.3880@tk2msftngp13.phx.gbl...
>>I want to write a statement to query object permisions in a database. How
>>do I do this. Thanks in advance for any help.
>>
>
Hi
Look at sp_helprotect in Books Online.
e.g.
This example lists the permissions for the titles table.
EXEC sp_helprotect 'titles'
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program:
http://www.microsoft.com/mvp Blog:
http://www.msmvps.com/epprecht/ [quoted text, click to view] "foobar" <esuey@inbizservices.com> wrote in message
news:u5$UmjcRFHA.3880@tk2msftngp13.phx.gbl...
>I want to write a statement to query object permisions in a database. How
>do I do this. Thanks in advance for any help.
>
