Re: field level security question

From: djc (noone_at_nowhere.com)
Date: 01/13/04 

Date: Tue, 13 Jan 2004 12:57:07 -0500

ok. Thanks.

"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
news:e9E0y3f2DHA.1720@TK2MSFTNGP10.phx.gbl...
> In both the cases, you get an error. How the application behaves depends
on,
> how it is trapping each error. The application could be handling the
error,
> and displaying no data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "djc" <noone@nowhere.com> wrote in message
> news:u3HU80f2DHA.1752@tk2msftngp13.phx.gbl...
> Thanks for the quick response! So then based on this I assume there is
> different behavior based on whether you are opening a form based on a
table
> that you have no permission on entirely or you are opening a form based on
a
> table that you are restricted from a few fields but have access to other
> fields. Just want to make sure I understand if this is a distinction
because
> I have opened a form based on a table that the user has no permission on
and
> I did not receive any errors, just no data. More specifically, it was a
> listBox control that gets data from a query of the sql server table. The
> list box just remained empty. no error.
>
> thanks again.
>
>
> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> news:uR54Dqf2DHA.556@TK2MSFTNGP11.phx.gbl...
> > If you deny/revoke permissions on a specific column, then the calling
> > application will receive an error, when it tries to access that column.
So
> > no, the forms application will fail.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "djc" <noone@nowhere.com> wrote in message
> > news:OnT1Gkf2DHA.2160@TK2MSFTNGP12.phx.gbl...
> > I have a simple interface created with access2002 that just uses an ODBC
> > connection to 2 tables that reside on a SQL2000 server. I need to give
> this
> > utility to persons that should not see a couple particular fields of the
> > tables. (obviously the utility was not designed for their use.. this is
a
> > recent change in requirement) I see the option to limit permissions
right
> > down to the field level on sql2000 server. If I get rid of all
permissions
> > to just a few fields (not key fields required for joins anywhere in the
> > utility) for these particular users will the utility still work? I have
> > launched the utility before adding a user account, by mistake, prior and
> the
> > utility opens except their is just no data. For example, a form is based
> on
> > a table, the user does not have an account that allows access to this
> table,
> > and the form opens but just shows no data. I am hoping if I deny access
to
> > just a few fields that the form would open and only those fields would
be
> > blank. But the rest of the data would be there. Is this the case? Would
it
> > also be the same in the case of forms that display info based on a JOIN
of
> > the 2 tables? (not denying access to primary/foreign key fields that the
> > join requires)
> >
> > I want to make sure I'm doing an 'ok' thing before I do this. For
example,
> > even if I don't get errors what else may go wrong that I'm not seeing?
> >
> > Thanks in advance for any help.
> >
> >
> >
>
>
>

Relevant Pages

  • I was the owner of the access database. and now the owner is unkow
    ... that I don't have the necessary permission. ... Every once and while the login ... Microsoft Access MVP ... cut Access opens and I immediately get the message that I dont have ...
    (microsoft.public.access.security)
  • Re: DBEngine.CompactDatabase and Permissions
    ... True, the risk is small but if it brings no benefit, then what's the ... permission to compact from Access but not to run the CompactDatabase method. ... you should get an exclusive lock to do the compact. ... as David Epson says that Jet no longer opens the file. ...
    (microsoft.public.access.security)
  • Cannot open in exclusive mode......
    ... The Design changes bit is the interesting point here for me. ... The application-specific permission settings do not grant Local ... login, hidden startup form opens, splash screen ... opens, splash screen closes, opens hidden form for persisant link to ...
    (microsoft.public.access.security)
  • Re: Word 2007 Wont directly open documents from Sharepoint
    ... Client Integration Feature is turned on. ... something wrong concerning the "Use Client Integration Features" permission. ... It is also possible that logging in on their workstation with a different ... Instead Word opens and just sits there. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to write a macro to open a file read-only?
    ... I haven't looked into it but I imagine it's possible to change the readonly attribute of a text file within a macro before opening it. ... One is the file access rights which exist before anyone even opens it. ... A file whose permission is 'writeable' can be opened in readonly mode, but a file that doesn't have the 'write' permission cannot be opened in write mode. ...
    (microsoft.public.excel.programming)