permissions

[Everaldo Ricardo]

how to print group/user permissions ?

 

[Sylvain Lafontaine]

You should ask this question in a newsgroup directly related to SQL-Server,
like m.p.sqlserver.programming or m.p.sqlserver.server .

The undocumented way would be to query the table sysobjects but the official
way is probably to use the INFORMATION_SCHEMA views; see for exemple:

http://www.databasejournal.com/features/mssql/article.php/1460131

http://www.sqlservercentral.com/columnists/bkelley/informationschemaviews.asp

 

[Everaldo Ricardo]

Hi Sylvain, I mean Groups/users from Access User level security(mdw).I know
that I should ask this question in a Pure MsAccess Group, I'm Sorry, but
maybe you can help me.

 

[Norman Yuan]

Since you are posting in ADP NG, I assume you are talking Access ADP
application(?). If so, no Access user level security is involved, all
security is on the SQL Server back end backend.

 

[Everaldo Ricardo]

I know Norman, you're right, sorry again

Since you are posting in ADP NG, I assume you are talking Access ADP
application(?). If so, no Access user level security is involved, all
security is on the SQL Server back end backend.