Re: Reading User Permissions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Berny (BlancoB)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 15:29:04 -0400

I'm sure "Sp_helprotect is the key..." but my knowledge is very limited in
sql.

Is there an easy way of seeing if someone has update permission on a field
in one of my existing Queries?

"oj" <nospam_ojngo@home.com> wrote in message
news:eyBBUJYIEHA.3528@TK2MSFTNGP09.phx.gbl...
> Sp_helprotect is the key...
>
> http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_help_1rxw.asp
>
> --
> -oj
> http://www.rac4sql.net
>
>
> "Berny" <BlancoB at msn Dot com> wrote in message
> news:O8xxV6XIEHA.2596@TK2MSFTNGP10.phx.gbl...
> > Can someone point me in the right direction?
> >
> >
> >
> > I am trying to turn-off (hide) specific objects on a form based on the
> > current user's permissions (access).
> >
> >
> >
> > I was trying to use the Permissions() function but I can't seem to
figure
> it
> > out.
> >
> >
> >
> > When I use the following in the Query used for the Form:
> >
> > permissions(dbo.SD_Rqs.Scoped)
> >
> >
> >
> > I get an error message that reads:
> >
> > "Syntax error converting the varchar value 'N' to a column of data type
> > int."
> >
> >
> >
> > I get the same error when I try the following conversion:
> >
> >
> >
> > CONVERT (varchar(20), permissions(dbo.SD_Rqs.Scoped))
> >
> >
> >
> > Am I using the proper function? Or should I be using some other
> technique?
> >
> >
> >
> > Any help would be greatly appreciated.
> >
> >
>
>

Relevant Pages

  • Re: Reading User Permissions
    ... "Berny" <BlancoB at msn Dot com> wrote in message ... > Is there an easy way of seeing if someone has update permission on a field> in one of my existing Queries? ... >>> I get an error message that reads: ... >>> Am I using the proper function? ...
    (microsoft.public.access.formscoding)
  • Re: Reading User Permissions
    ... "Berny" <BlancoB at msn Dot com> wrote in message ... > Is there an easy way of seeing if someone has update permission on a field> in one of my existing Queries? ... >>> I get an error message that reads: ... >>> Am I using the proper function? ...
    (microsoft.public.access.forms)
  • Re: Reading User Permissions
    ... sql. ... Is there an easy way of seeing if someone has update permission on a field ... >> Am I using the proper function? ...
    (microsoft.public.access.forms)
  • Re: Reading User Permissions
    ... sql. ... Is there an easy way of seeing if someone has update permission on a field ... >> Am I using the proper function? ...
    (microsoft.public.sqlserver.programming)
  • Re: Reading User Permissions
    ... sql. ... Is there an easy way of seeing if someone has update permission on a field ... >> Am I using the proper function? ...
    (microsoft.public.office.developer.vba)