Drizzle

test access control list for catalogs

Registered by Patrick Crews

We want to ensure that we have testcases for the access control list
We use the mysql version as a template:
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html

Blueprint information

Status:
Not started
Approver:
Patrick Crews
Priority:
Undefined
Drafter:
Patrick Crews
Direction:
Needs approval
Assignee:
Patrick Crews
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

These testcases will cover the ACL cases in regards to catalogs
All cases should include positive and negative cases.
Negative cases should include trying to exercise priviliges outside of the users' privileged catalog
(eg user1 has access to catalog user1_cat. We want him to try things in user!1_cat)

Work items:
[ patrick-crews ] CREATE CATALOG privilege: TODO
[ patrick-crews ] DROP CATALOG privilege: TODO
[ patrick-crews ] CREATE TABLE privilege: TODO
[ patrick-crews ] DROP TABLE privilege: TODO
[ patrick-crews ] GRANT privilege: TODO
[ patrick-crews ] ALTER TABLE privilege: TODO
[ patrick-crews ] DELETE TABLE privilege: TODO
[ patrick-crews ] INDEX privilege: TODO
[ patrick-crews ] INSERT privilege: TODO
[ patrick-crews ] SELECT privilege: TODO
[ patrick-crews ] UPDATE privilege: TODO
[ patrick-crews ] CREATE TEMPORARY TABLES privilege: TODO
[ patrick-crews ] LOCK TABLES privilege: TODO
[ patrick-crews ] EXECUTE privilege(?): TODO
[ patrick-crews ] FILE privilege: TODO
[ patrick-crews ] CREATE USER privilege: TODO
[ patrick-crews ] PROCESS privilege: TODO
[ patrick-crews ] RELOAD privilege: TODO
[ patrick-crews ] SHOW DATABASES privilege: TODO
[ patrick-crews ] SHUTDOWN privilege: TODO
[ patrick-crews ] SUPER privilege: TODO
[ patrick-crews ] ALL privilege: TODO
[ patrick-crews ] USAGE privilege: TODO

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.