Re: Execute permission denied on a Foreign Key?
Do they have the appropiate permissions the tables reference to perhaps
Update the references key or delete some values in the FKKey-Table ? There
is a
article, somehow explain som nice :-)
http://groups.google.de/groups?q=dri+sql+server+permission&hl=de&lr=&selm=O2mOxTVVCHA.1748%40tkmsftngp09&rnum=1
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"Van Jones" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:013401c54aa6$68ff5e40$a501280a@xxxxxxxxxx
>I have some developers getting an execute permission
> denied an a FK. It's not a FK violation. It appears that
> the code and sps they are running aren't even referencing
> the table that the FK is on. I can run all their SPs in
> Query Analyzer and they run fine. Not sure what it could
> be. Has anyone saw this error before? Can you have
> permissions on FKs? I did a dbcc checkdb on the database
> and it came back with 0 errors.
>
> Thanks,
>
> Van
.
Relevant Pages
- Re: TypeError while checking for permissions with os.access() on windows xp
... Then backup_dest is a reference to the variable self.__backup_dest. ... I'm using optparse in my script (that code for checking for permission is a part of my backup script). ... print "Have no permissions on for reading ...
(comp.lang.python) - Re: Is it secure to not refuse permissions in a non-referenced assembly?
... You don't necessarily need to refuse explicitily all unneeded permissions. ... proper combination of RequestMinimum and RequestOptional allows you ... > instance, query a database, but if I do not reference the assembly that> would allow that, I would think that I can prove that my app doesn't query a> DB just by looking at its referenced assemblies. ... then I would have to add> references to several assemblies I don't use just to refuse all 19 built-in> permissions. ...
(microsoft.public.dotnet.security) - Re: Is it secure to not refuse permissions in a non-referenced assembly?
... You don't necessarily need to refuse explicitily all unneeded permissions. ... > instance, query a database, but if I do not reference the assembly that> would allow that, I would think that I can prove that my app doesn't query a> DB just by looking at its referenced assemblies. ... then I would have to add> references to several assemblies I don't use just to refuse all 19 built-in> permissions. ...
(microsoft.public.dotnet.security) - Re: [PATCH] implement in-kernel keys & keyring management [try #4]
... One feature that appears to be missing is a key handle or key reference, ... the same permission mask as the parent, reducible, of course. ... reference is revoked it also revokes all cloned references, ...
(Linux-Kernel) - Re: Error# displayed in fields
... It would be good to check that he has the correct SPs for Win2000 also. ... Does the other form edit the same record as the original form? ... Or does a Recalc force the correct display? ... It would seem that if it was a reference issue that the numeric ...
(microsoft.public.access.forms) |
|
