why does NT user have access to all tables?

  • Thread starter Thread starter Bill D
  • Start date Start date
B

Bill D

If I use a standard login and assign it permissions to limited number of
objects in db, it works. I open an ADP and what it shows in the tables tab
is just the tables that user has permissions for.

But, when I make a security logon that is nt integrated, and then add that
user to the database. they get permissions on all objects, regardless of
permissions I set in the database.

Is this just a flaw of oledb?
I've tried different netlibs to no avail.
 
Hello there.
The problem that I'm experiencing is similar to what you
have described here...

(ie., AS DBO, I HAVE NO PROBLEMS ACCESSING ALL DBO OBJECTS
IN MY DATABASE (using win integrated security). BUT WHEN I
GRANT PERMISSIONS TO USERS (windows integrated security)
ON CERTAIN DB OBJECTS, USING ENTERPRISE MANAGER OR RUNNING
PROCS IN QUERY ANALYZER, THE PERMISSIONS GRANTED ON
OBJECTS FROM SQL SERVER DOES NOT MATCH USER'S PERMISSIONS
FROM WITHIN 2003 ADP FILE. I tried different strategies,
such as granting permissions to db roles, then adding
users to roles; I also tried just adding logins for Win
user groups as db users, then specifying permissions.
These variations did not work either...)

Wondering if you found a workaround or fix to your
problem, and If so, if you could kindly share...

Thanks for your time and help!
 
Back
Top