>> check have sql permission

Jonathan

Guest

Posts: n/a

16th Jul 2008

Hi, we have an Access UI linked to SQL. We periodically send updates to
clients. It would be nice if only the DBAs ran these updates. However,
sometimes a user tries to run the updates when they do not have sysadmin
permission. Is there a programmatic way to check user permissions on SQL?

Any ideas or suggestions appreciated :-)

Many thanks,
Jonathan

« Users have dbSecFullAccess but can't read connect string | Access 2007 and "current user" »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Check folder permission before transfertext	B. Meincke	Microsoft Access Form Coding	0	28th Jan 2008 09:10 PM
Re: Check File or Folder Permission	Kevin Spencer	Microsoft Dot NET	1	2nd Jan 2007 12:33 PM
Check for permission does not work	Marius Groenendijk	Microsoft VB .NET	3	2nd Nov 2004 09:16 AM
Permission check for secured subfolders?	TK	Microsoft ASP .NET	3	14th Jul 2004 04:43 PM
Check permission on files and directories	Jonas Nilsson	Microsoft ASP .NET	2	13th Aug 2003 02:57 PM