Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

User Table/Query Access question

Discussion in 'Information Technology' started by jayson.cervantes@gmail.com, Jul 28, 2006.

  1. jayson.cervantes@gmail.com

    jayson.cervantes@gmail.com
    Expand Collapse
    Guest

    To set the stage: I have an access database with security controled by
    a .mdw file. I have user "John" who has Read/Update/Insert access to a
    table but currently can do those functions through a form as he has no
    access to the table itself because the database window is disabled. The
    form that he uses to update the table locks certian fields from him so
    he cannot update certian elements.

    My issue is that I need to give John the ability to write queries from
    the data in the tables but I do not want him to be able to update data
    in these tables directly (something he could do through a query or by
    directly updating the table) once he gets access to the Database
    window.

    How can I keep him as a user of the application where he can only
    update the table through my form but he is free to create queries and
    run queries on the tables?

    Thanks,
    Jason
     
  2. Loading...

    Similar Threads Forum Date
    After FIR, Social Media Users Wary of Offensive Jokes on Sardars Information Technology Oct 2, 2013
    USA US govt secretly collecting data on millions of Verizon users: Report Breaking News Jun 6, 2013
    using spiritual name as a username Questions and Answers Aug 23, 2012
    Audience of 3 Million Users Receiving Anti-Sikh Messages Hard Talk Sep 17, 2010
    General How can I change my username ? Hard Talk Sep 4, 2010

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    AFAIK Oracle is the only player that gives you the possibility to assign
    Column level security
    an Access workaround is to add WITH OWNERACCESS OPTION to the end of the
    Form's Recordsource (Query)
    and revoke anything but "read" access to the underlying Table for the
    User/Group

    HTH

    Pieter

    <jayson.cervantes@gmail.com> wrote in message
    news:1153870111.924636.26050@m73g2000cwd.googlegroups.com...
    > To set the stage: I have an access database with security controled by
    > a .mdw file. I have user "John" who has Read/Update/Insert access to a
    > table but currently can do those functions through a form as he has no
    > access to the table itself because the database window is disabled. The
    > form that he uses to update the table locks certian fields from him so
    > he cannot update certian elements.
    >
    > My issue is that I need to give John the ability to write queries from
    > the data in the tables but I do not want him to be able to update data
    > in these tables directly (something he could do through a query or by
    > directly updating the table) once he gets access to the Database
    > window.
    >
    > How can I keep him as a user of the application where he can only
    > update the table through my form but he is free to create queries and
    > run queries on the tables?
    >
    > Thanks,
    > Jason
    >
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    AFAIK Oracle is the only player that gives you the possibility to assign
    Column level security
    an Access workaround is to add WITH OWNERACCESS OPTION to the end of the
    Form's Recordsource (Query)
    and revoke anything but "read" access to the underlying Table for the
    User/Group

    HTH

    Pieter

    <jayson.cervantes@gmail.com> wrote in message
    news:1153870111.924636.26050@m73g2000cwd.googlegroups.com...
    > To set the stage: I have an access database with security controled by
    > a .mdw file. I have user "John" who has Read/Update/Insert access to a
    > table but currently can do those functions through a form as he has no
    > access to the table itself because the database window is disabled. The
    > form that he uses to update the table locks certian fields from him so
    > he cannot update certian elements.
    >
    > My issue is that I need to give John the ability to write queries from
    > the data in the tables but I do not want him to be able to update data
    > in these tables directly (something he could do through a query or by
    > directly updating the table) once he gets access to the Database
    > window.
    >
    > How can I keep him as a user of the application where he can only
    > update the table through my form but he is free to create queries and
    > run queries on the tables?
    >
    > Thanks,
    > Jason
    >




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  5. jayson.cervantes@gmail.com

    jayson.cervantes@gmail.com
    Expand Collapse
    Guest

    Im faking colum level security by having the form look at the user's
    groups and determining what fields to unlock/lock. Thats not the issue.
    I want to give this guy the ability to create read-only queries and not
    allow him to update tables/queries directly.

    Thanks,
    Jason

    Pieter Wijnen wrote:
    > AFAIK Oracle is the only player that gives you the possibility to assign
    > Column level security
    > an Access workaround is to add WITH OWNERACCESS OPTION to the end of the
    > Form's Recordsource (Query)
    > and revoke anything but "read" access to the underlying Table for the
    > User/Group
    >
    > HTH
    >
    > Pieter
    >
    > <jayson.cervantes@gmail.com> wrote in message
    > news:1153870111.924636.26050@m73g2000cwd.googlegroups.com...
    > > To set the stage: I have an access database with security controled by
    > > a .mdw file. I have user "John" who has Read/Update/Insert access to a
    > > table but currently can do those functions through a form as he has no
    > > access to the table itself because the database window is disabled. The
    > > form that he uses to update the table locks certian fields from him so
    > > he cannot update certian elements.
    > >
    > > My issue is that I need to give John the ability to write queries from
    > > the data in the tables but I do not want him to be able to update data
    > > in these tables directly (something he could do through a query or by
    > > directly updating the table) once he gets access to the Database
    > > window.
    > >
    > > How can I keep him as a user of the application where he can only
    > > update the table through my form but he is free to create queries and
    > > run queries on the tables?
    > >
    > > Thanks,
    > > Jason
    > >
     
  6. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    If your queries include WITH OWNERACCESS OPTION you can revoke DML rights
    from the underlying table & give him the rights he needs per query instead.
    He will then not be able to make updatable queries.

    Another way would be to give him a seperate Db with all the tables linked &
    provide him with read only access to the tables in that

    Pieter

    <jayson.cervantes@gmail.com> wrote in message
    news:1153871482.971218.214290@m79g2000cwm.googlegroups.com...
    > Im faking colum level security by having the form look at the user's
    > groups and determining what fields to unlock/lock. Thats not the issue.
    > I want to give this guy the ability to create read-only queries and not
    > allow him to update tables/queries directly.
    >
    > Thanks,
    > Jason
    >
    > Pieter Wijnen wrote:
    >> AFAIK Oracle is the only player that gives you the possibility to assign
    >> Column level security
    >> an Access workaround is to add WITH OWNERACCESS OPTION to the end of the
    >> Form's Recordsource (Query)
    >> and revoke anything but "read" access to the underlying Table for the
    >> User/Group
    >>
    >> HTH
    >>
    >> Pieter
    >>
    >> <jayson.cervantes@gmail.com> wrote in message
    >> news:1153870111.924636.26050@m73g2000cwd.googlegroups.com...
    >> > To set the stage: I have an access database with security controled by
    >> > a .mdw file. I have user "John" who has Read/Update/Insert access to a
    >> > table but currently can do those functions through a form as he has no
    >> > access to the table itself because the database window is disabled. The
    >> > form that he uses to update the table locks certian fields from him so
    >> > he cannot update certian elements.
    >> >
    >> > My issue is that I need to give John the ability to write queries from
    >> > the data in the tables but I do not want him to be able to update data
    >> > in these tables directly (something he could do through a query or by
    >> > directly updating the table) once he gets access to the Database
    >> > window.
    >> >
    >> > How can I keep him as a user of the application where he can only
    >> > update the table through my form but he is free to create queries and
    >> > run queries on the tables?
    >> >
    >> > Thanks,
    >> > Jason
    >> >

    >




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page