J
JK
I DESPERATELY NEED INFORMATION ON HOW TO TROUBLESHOOT
ACCESS PROBLEMS WITH SQL OBJECTS FROM MY ADP (ACCESS 2003)
APPLICATION.
AS DBO, I HAVE NO PROBLEMS WITH 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 ACCESS IN
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...
THIS SEEMS TO BE A BUG (I ALREADY HAVE SP3A INSTALLED, BUT
THE PROBLEM STILL EXISTS.)
THIS IS A MAJOR SETBACK TO OUR ROLL-OUT! PLEASE HELP!
Thank you for your help and immediate response.
ACCESS PROBLEMS WITH SQL OBJECTS FROM MY ADP (ACCESS 2003)
APPLICATION.
AS DBO, I HAVE NO PROBLEMS WITH 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 ACCESS IN
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...
THIS SEEMS TO BE A BUG (I ALREADY HAVE SP3A INSTALLED, BUT
THE PROBLEM STILL EXISTS.)
THIS IS A MAJOR SETBACK TO OUR ROLL-OUT! PLEASE HELP!
Thank you for your help and immediate response.