Table loseing primary key when not local admin?

[Brian Henry]

This is just bugging me... We store our database on SQL Server 2000 with
service pack 4 installed on it. When a user is using the app we developed,
if they are a local admin it works perfectly fine... If they are not a local
admin, the app throws an exception with the message "Table does not have a
primary key"... any idea why someone who is logged into the network as a
non-admin would have this happen to them? yet when someone is logged in as
an admin (aka me) it does not? does it have anything to do with permissions
on sql server or just .NET stuff? thanks!

 

[William \(Bill\) Vaughn]

Yes, without access to the code, my first guess would be that the account
you have setup for the individual (I'm assuming SSPI security) does not have
sufficient rights or a proper initial catalog defined.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Brian Henry]

well basicly its create a blank dataset.. create a data adapter with
Sel/Upd/Del/Insert stored procedures... fill the dataset's table with fill
schema then fill with data then try to find an item in the table by key
using the find procedure... I kind of think its database side also too
though yes we are usign windows authentication, and we did notice that when
we add them as local admins to sql server 2000's server it suddenly works...
remove them from that group, it doesnt work.. any idea on how to fix this?
thanks because they have access to the database to start with and have all
the permissions on the stored procedures that they use to interact with the
database through a Role permission set.

 

[William \(Bill\) Vaughn]

Do you have an exception handler on the Fill? Do you have individual or
Windows group rights assigned to the target table or SP? Did you try to
access the data from OSQL or somesuch from the user's system (with their
rights)? Does it have access to the data?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________