SQL 6.5 - Rights - Not Working Correctly
From: Dave (dnajac@ezecastlesoftware.com)
Date: 10/01/02
- Next message: Dave: "SQL 6.5 - Rights - Not Working Correctly"
- Previous message: claudia chai: "OPENROWSET"
- Next in thread: Dave: "SQL 6.5 - Rights - Not Working Correctly"
- Reply: Dave: "SQL 6.5 - Rights - Not Working Correctly"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Dave" <dnajac@ezecastlesoftware.com> Date: Tue, 1 Oct 2002 12:09:40 -0700
I have one particular SQL 6.5 server that I am having a
rights issue with for certain SQL users that are a member
of a restricted rights group in one of the databases on
the server. As an example, I have a user named 'Dave'
that is a member of the group 'ReadOnly' in database XYZ.
In the XYZ database there is a table named Table1 that
allows the 'ReadOnly' group to have SELECT access only (no
other rights or restrictions). The stange thing is that
this user is able to INSERT, UPDATE and DELETE records in
this table (he is not a member of any other groups, dbo,
etc). The same configuration on other SQL 6.5 servers
works fine. Has anyone encountered this issue before?
Thanks,
Dave
- Next message: Dave: "SQL 6.5 - Rights - Not Working Correctly"
- Previous message: claudia chai: "OPENROWSET"
- Next in thread: Dave: "SQL 6.5 - Rights - Not Working Correctly"
- Reply: Dave: "SQL 6.5 - Rights - Not Working Correctly"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
