I know it does currently, but should

SELECT * FROM Databases

return the configuration database as well as the user ones?

Roy Lambert

Roy,

<< I know it does currently, but should

SELECT * FROM Databases

return the configuration database as well as the user ones? >>

Sure, why not ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< I know it does currently, but should
>
> SELECT * FROM Databases
>
> return the configuration database as well as the user ones? >>
>
>Sure, why not ?

Anything else in there is a user defined database and is under the users control Configuration is a system database and not under users control.

Roy Lambert

Roy,

<< Anything else in there is a user defined database and is under the users
control Configuration is a system database and not under users control. >>

Yes, but the Configuration database is also present in the
DatabasePrivileges table, which is important for making sure that an
authorization (user/role) has the proper SELECT privileges for the
Configuration database.

I'll have to think about this further.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


On the basis I've never changed the privileges for the Configuration table I didn't know that

Roy Lambert

Roy,

<< On the basis I've never changed the privileges for the Configuration
table I didn't know that >>

Well, I axed the Configuration database from both tables (Databases and
DatabasePrivileges) because you can't change the database privileges
anyways.  I was mistakenly thinking of the effective privileges, not the
actual privilege assignments.

Which reminds me, I need to add a system table for effective privileges.....


--
Tim Young
Elevate Software
www.elevatesoft.com