Does PUBLIC override user-defined roles?

• Previous message: Steve Thompson: "Re: MSN HOME PAGE"
• Next in thread: Carlos Eduardo Rojas: "Re: Does PUBLIC override user-defined roles?"
• Reply: Carlos Eduardo Rojas: "Re: Does PUBLIC override user-defined roles?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Fri, 6 Jun 2003 07:07:37 -0700

I'm hoping I'm going to word this right...

We have a database within which the PUBLIC group does not
have access to any tables. Instead, we've created a user-
defined role called "ReadAccess" which we're using to
restrict all but SELECT to the tables in the database.

This ReadAccess role has the Domain Users group of our
domain in it, and our server is set to Mixed security.
When a domain user logs into SQL Analyzer using a Trusted
connection, the user sees the tables fine and can SELECT
from them.

However, when the same user tries to create a report in
Crystal Reports, the user does not see the tables she has
SELECT access to.

I know Crystal is not a Microsoft product, but I'm
wondering if we need to give some sort of extra access to
the user to allow them to get a list of tables they have
access to? By not being a member of the PUBLIC group,
perhaps they don't have this access by default? Is it
possible that PUBLIC group membership (or non-membership
in this case) overrides the rights you have in other user-
defined roles?

Thanks for any guidance you can lend.

EB

• Previous message: Steve Thompson: "Re: MSN HOME PAGE"
• Next in thread: Carlos Eduardo Rojas: "Re: Does PUBLIC override user-defined roles?"
• Reply: Carlos Eduardo Rojas: "Re: Does PUBLIC override user-defined roles?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]