User Groups

[Duncan Groenewald]

The CREATE USER function includes a SET GROUPS group_list syntax.

How do I create a group and how are groups used ?

Is there any documentation on GROUPS ?

Thanks


---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

[Tobias Downer]

Hi Duncan,

The purpose of the USER GROUP syntax is to attach a tag to the user.
Currently the only meaningful use of the syntax is to allow the
inclusion of a user into the 'secure access' group which grants the user
rights to create and delete users and modify some of the system tables.

Toby.

Post by Duncan Groenewald
The CREATE USER function includes a SET GROUPS group_list syntax.
How do I create a group and how are groups used ?
Is there any documentation on GROUPS ?
Thanks

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

[Duncan Groenewald]

I take it there is no way to create groups with specific access
rights and then to add users to these groups ?

Post by Tobias Downer
Hi Duncan,
The purpose of the USER GROUP syntax is to attach a tag to the
user. Currently the only meaningful use of the syntax is to allow
the inclusion of a user into the 'secure access' group which grants
the user rights to create and delete users and modify some of the
system tables.
Toby.

Post by Duncan Groenewald
The CREATE USER function includes a SET GROUPS group_list syntax.
How do I create a group and how are groups used ?
Is there any documentation on GROUPS ?
Thanks

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

[Tobias Downer]

Hi,

Not at this time, however the username and password itself can act as a
group since all access rights are tied to a username. I'm not sure an
extra level of indirection where groups would grant user rights would be
userful in Mckoi, however the possibility of adding something like this
has come to mind.

Toby.

I take it there is no way to create groups with specific access rights
and then to add users to these groups ?

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com