Granting SELECT to role on multiple tables

From: Sharon (oidhchenospam_at_hotmail.com)
Date: 06/13/03

  • Next message: Ray Higdon: "Granting SELECT to role on multiple tables" 
    Date: Fri, 13 Jun 2003 02:02:40 -0700

    Hi,

    I am trying to grant SELECT permissions to a server role
    on multiple tables within a database, but it doesn't seem
    possible. Is there an easy way to do it - there are
    nearly a hundred tables the role needs permissions on, but
    it can't have SELECT on all tables in the database.

    Any help would be greatly appreciated.

    Thanks very much

    Sharon

  • Next message: Ray Higdon: "Granting SELECT to role on multiple tables"

    Relevant Pages

    • Re: Beginning C# Q
      ... What is a typical method for handling multiple ... when the user submits changes to the database that the users ... > Groups table, which defines which Groups users belong to, and a Permissions ... That is why an Interface is called an Interface. ...
      (microsoft.public.dotnet.framework)
    • Allowing Multiple users to open the front end
      ... So if I am understanding everything correctly the only way to allow multiple ... users to open a "Microsoft Access 2007 Front End" is to allow all users full ... permissions I must convert the database from .accdb to .mdb and loose the ...
      (microsoft.public.access.security)
    • View Diagrams
      ... Is there a way to change the view permissions for database diagrams? ... We have multiple people who work on our databases, ...
      (microsoft.public.sqlserver.server)
    • Re: List Users Permissions down to table.column action
      ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
      (microsoft.public.sqlserver.security)
    • Re: User access on a company intranet
      ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
      (microsoft.public.access.security)
    • Quantcast