Thread: Permission Question

Permission Question

From
"Dan Wilson"
Date:
I'm having a problem understanding the table level permissions.

I created a dummy user for individuals to sample a product connecting to my
database.

The product lists all database and tables within each database, however the
dummy account does not have any kind of permissions within the databases
other than the sample db.

Why are they able to list all the relations within the other databases?
Shouldn't this information be considered off limits to a user without select
permissions on the database?

I, personally, would prefer it that way.  Thus they cannot see the basic
structure of my "live" db's.

Just asking....

-Dan Wilson