Re: SYSOBJECT Permissions needed to see subform?
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Feb 2006 20:38:58 -0600
The public role should have select permissions on the sysobjects system
table unless you've removed those default permissions. Some data access
API's rely on system table public permissions for proper operation.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"AkAlan" <AkAlan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5F94196B-5FA6-4EDF-BCD3-5D7B75AED00B@xxxxxxxxxxxxxxxx
I have a form with a subform on my Access Project and while test a Role I
found that unless I gave SELECT permission to the sysobject table a
particular subform would not display any data, actually it was a blank
white
box where the subform should have been. The work around is to grant the
permission but I would like to know why it is needed. Also are there other
system tables I should be granting to everyone so other unforseen problems
don't occur? Thanks.
.
- Prev by Date: Re: Server Roles Process administrators
- Next by Date: Re: Active Directory / Groups + MS SQL (yikes???)
- Previous by thread: Re: SQL 2000 drops connection, DDOS attack?
- Next by thread: Error when trying to execute a job from windows service.
- Index(es):
Relevant Pages
|
|
