[dbsrgits/DBIx-Class-Historic.git] / PRVILEGES.SKETCH

Ash's thoughts on privilege/GRANT abstraction for DBIC

So my first thought was some hideous mismash of lots of functions like:
->grant($user, $schema, \@privileges)

But DB2 and Oracle both support groups - and its a bit evil

So while driving to badminton I came up with the following "idea".

->grant({ user => $user, object => $table_or_object, privileges => \@privs})
->grant({ group => $group, ... <as above> })
->grant({ user=> $user, add_to_group => $group});

Thoughts?
Commit	Line	Data
6f6fd6c6	1	Ash's thoughts on privilege/GRANT abstraction for DBIC
	2
	3	So my first thought was some hideous mismash of lots of functions like:
	4	->grant($user, $schema, \@privileges)
	5
	6	But DB2 and Oracle both support groups - and its a bit evil
	7
	8	So while driving to badminton I came up with the following "idea".
	9
	10	->grant({ user => $user, object => $table_or_object, privileges => \@privs})
	11	->grant({ group => $group, ... <as above> })
	12	->grant({ user=> $user, add_to_group => $group});
	13
	14	Thoughts?