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.

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

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.