Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / January 2007

Tip: Looking for answers? Try searching our database.

permissions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Everaldo Ricardo - 24 Jan 2007 20:08 GMT
how to print group/user permissions  ?
Sylvain Lafontaine - 25 Jan 2007 19:51 GMT
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

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

> how to print group/user permissions  ?
Everaldo Ricardo - 26 Jan 2007 11:36 GMT
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.

> You should ask this question in a newsgroup directly related to
> SQL-Server, like m.p.sqlserver.programming or m.p.sqlserver.server .
[quoted text clipped - 8 lines]
>
>> how to print group/user permissions  ?
Norman Yuan - 26 Jan 2007 14:09 GMT
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.

> 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,
[quoted text clipped - 12 lines]
>>
>>> how to print group/user permissions  ?
Everaldo Ricardo - 26 Jan 2007 18:26 GMT
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
[quoted text clipped - 16 lines]
>>>
>>>> how to print group/user permissions  ?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.