![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 6 of 6 total |
![]() |
Mon, Sep 14 2009 11:56 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | I know it does currently, but should
SELECT * FROM Databases return the configuration database as well as the user ones? Roy Lambert |
Mon, Sep 14 2009 12:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Tue, Sep 15 2009 3:50 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Tue, Sep 15 2009 12:55 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Wed, Sep 16 2009 3:13 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
On the basis I've never changed the privileges for the Configuration table I didn't know that ![]() Roy Lambert |
Wed, Sep 16 2009 3:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |