Re: Grant admin rights to user temporarily

Graham,

Thanks alot... "run with owner permissions" (RWOP) query was the solution
that I needed...

Again thank you

Scuba79

"Graham Wideman [Visio MVP]" wrote:

> scuba:
>
> One of the points of not giving a user rights is to also not give them
> rights to give themself rights... When you say:
>
> > "I need to be able to give them rights"
>
> .... you are not logged on when they are running your code... they are.
> Consequently the code, acting with the permissions of your user, can't give
> your user more rights.
>
> You don't say what the code does that needs these special rights, but it's
> possible you could solve your problem with the help of a "run with owner
> permissions" (RWOP) query -- that's a query that you enable to run with the
> permissions of a user that has more permissions, regardless of who the
> actual user is who runs it.
>
> From Help topic "Change a query's permissions":
>
> "you can assign others permission to view the data your query returns or, in
> the case of an action query, to run the query, even if they are otherwise
> restricted from viewing the query's underlying table or query. "
>
> Hope that helps,
>
> Graham
>
> "scuba79" <scuba79@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:CDF85DBA-5906-49C9-A350-3C50603B5FA6@xxxxxxxxxxxxxxxx
> >I have a secured database using a mdw file that was created with the
> > database. I have some code that will be run under one of the user
> > accounts.
> > That account does not have any rights to the tables. I need to be able to
> > give them rights to the tables just as long as the code is running. Here
> > is
> > the code that I'm currently using.
> >
> >
> > While Not rst.EOF
> > Set con = db.Containers("Tables")
> > Set doc = con.Documents(rst("Name"))
> > doc.UserName = "pdlead"
> > doc.Permissions = dbSecFullAccess
> > con.Documents.Refresh
> > rst.MoveNext
> > Wend
> >
> > ImportLoc = GetFileName
> >
> > this runs without any problems, however, when I click on another button.
> > I
> > get an error message stating that the user does not have permissions to
> > "work" with the tables.
> >
> > Any assistance is greatly appreciated
> >
>
> --
> ---------------------------------------------------
> Graham Wideman
> Microsoft Visio MVP
> ---------------------------------------------------
> Book/Tools:
> Visio 2003 Developer's Survival Pack
> Resources for programmable diagramming at:
> http://www.diagramantics.com
>
>
>
>
.

Loading