Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2014
    Posts
    2

    hi im trying to see how i can set user permissions on my database


    i was told i could use statements like GRANT SELECT ON Accounts TO Web_User, only i dont know WHERE to write the statement and how to write it so it grants read only permission to all web users.......im using Microsoft Access 2013, i really appreciate the help thanx alot

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    Never heard of GRANT SELECT with Access. Are you using SharePoint and SQL Server?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Sep 2014
    Posts
    2
    Quote Originally Posted by June7 View Post
    Never heard of GRANT SELECT with Access. Are you using SharePoint and SQL Server?
    no im using access 2013, maybe i was getting wrong information, do you know how else to do it?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    Sorry, no. Never built web database.

    I did do a quick Bing and everything I found refers to SQL Server, Oracle, SharePoint.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. User Permissions
    By escojr118 in forum Sample Databases
    Replies: 1
    Last Post: 11-02-2013, 02:19 AM
  2. User permissions - access 2010
    By Outlook in forum Security
    Replies: 3
    Last Post: 12-03-2012, 08:19 AM
  3. User Permissions
    By ccordner in forum Security
    Replies: 3
    Last Post: 03-14-2012, 10:50 AM
  4. Macro for user permissions
    By Loisw in forum Programming
    Replies: 1
    Last Post: 10-28-2010, 07:47 AM
  5. User and Group Permissions
    By sdondeti in forum Security
    Replies: 1
    Last Post: 02-01-2010, 05:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums