search

shlomi-noach / common-schema-legacy

Automatically exported from code.google.com/p/common-schema
5 stars 6 forks source link

procedure add_privilege(grantee, privilege(s)) #52

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What component are you suggesting? (view, table, function, procedure)

procedure

What will this new component do?

add a specific privilege to an account. eg:

call add_privilege('myuser@localhost', 'trigger');

The routine will add the 'trigger' privilege on whatever set of privileges that 
user has (possibly multiple, since a user may have sets of privileges per 
schema, table etc.)

Characteristics of the component? (e.g. NO SQL for stored function)

modifies sql data

Dependencies for component?

Original issue reported on code.google.com by sno...@outbrain.com on 12 Jan 2014 at 1:04