Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
User Admin |
Wed, Oct 14 2009 7:49 PM | Permanent Link |
Randy | I am creating a client server database where users will likely share certain tables and have certain private tables. There would also be employees
with access to all user tables. I think I get how to use roles and users in order to accomplish this but I am thinking that I would like an 'Administrator' application to create and administer users. Is it possible to use an EDBQuery to get a list of all users or how would I go about this. Or am I just suppose to use the DBManager, which is fine for me but not so usable I think for other possible end users. Thanks. |
Thu, Oct 15 2009 5:59 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Randy
What you need is Configuration.Users - in the sql help (I generally open EDBManager) look for a topic "configuration database" that shows all the tables in there. They can be queried just like normal tables (but making sure the query is pointing at the configuration database) but can only be manipulated using the special sql for them eg CREATE USER will work INSERT INTO Users will not Roy Lambert |
Thu, Oct 15 2009 11:39 AM | Permanent Link |
Randy | Thanks
I knew I was on the right track but it must have been late in the day. I found all the config documentation but was spinning my wheels trying to access it. It just never dawned on me that I needed another database component. Today is a new day. |
This web page was last updated on Friday, May 3, 2024 at 08:07 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |