R
rgtlsb
In SQL Server 2005 I can grant SELECT access to all tables/views to a
role by doing:
GRANT SELECT to NewRole
In Management Studio, a user in the NewRole role can select from any
table.
Yet, in a MS Access 2003 .adp with a connection setup for that same
user in NewRole, they cannot do an open (DoCmd.OpenTable or
DoCmd.OpenView) on that table or view unless SELECT has been
specifically granted to that table or view for the role. Why this
difference?
What is the recommended way to give access to these tables/views? Is
there a way to do this other than specifically granting SELECT to each
and every table/view?
Thank you,
Rob
role by doing:
GRANT SELECT to NewRole
In Management Studio, a user in the NewRole role can select from any
table.
Yet, in a MS Access 2003 .adp with a connection setup for that same
user in NewRole, they cannot do an open (DoCmd.OpenTable or
DoCmd.OpenView) on that table or view unless SELECT has been
specifically granted to that table or view for the role. Why this
difference?
What is the recommended way to give access to these tables/views? Is
there a way to do this other than specifically granting SELECT to each
and every table/view?
Thank you,
Rob