Adding a database user

From: Steve Caliendo (scaliendo_at_epion.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 14:09:35 -0400

Hi,

Could someone please tell me how to add a database user using a query? I
know how to set the appropriate permissions for tables of existing users,
but I can't figure out how to add a new user.

Thank you,

Steve

Relevant Pages

  • Re: restricted user level security
    ... All of my queries and macros are built off the Supervisor name, ... query, the query includes all of the fields and the CurrentUsercriteria. ... I changed the Run Permissions to Owner. ... you can set up user level security. ...
    (microsoft.public.access.security)
  • Re: Object permissions
    ... Who is the owner of the query? ... permissions does the owner have on the underlying tables? ... does the user have on the query; ... to 'owners' in the sql statement each time the code runs, ...
    (microsoft.public.access.security)
  • Re: Advance Security Issue Part II
    ... >> Okay, I've got the dual-mdw thing all straight, now I have a permissions ... >> created a Snapshot query to read that table. ... > because the effects of the WITH OWNER ACCESS ... > does not exist in the current workgroup file. ...
    (microsoft.public.access.security)
  • Re: rwop
    ... You can create a RWOP query for each of your ... base queries need to be RWOP; the queries based on these do not. ... esecially concerning how I have set the permissions for users. ... with the permissions of the owner. ...
    (microsoft.public.access.security)
  • Re: Renegade Form
    ... the 'owner' and would need permissions on the source tables/queries ... For this query, you can create a RWOP query for each of the underlying ... I do change recordsource but both queries have restricted permissions. ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)