Changeset: 67b7d7914960 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=67b7d7914960
Added Files:
sql/test/Users/privs2.sql
sql/test/Users/test_privs2.sql
Branch: Feb2013
Log Message:
adding missing test files
diffs (97 lines):
diff --git a/sql/test/Users/privs2.sql b/sql/test/Users/privs2.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/privs2.sql
@@ -0,0 +1,71 @@
+
+set schema "my_schema";
+
+create table version
+ (name varchar(10)
+ ,i int
+ )
+;
+
+insert into version
+ (name
+ ,i
+ )
+values
+ ('test1'
+ ,1
+ )
+;
+
+create function insertversion(iname varchar(10)
+ ,ii int
+ ) returns int
+begin
+
+ insert into version
+ (name
+ ,i
+ )
+ values
+ (iname
+ ,ii
+ )
+ ;
+
+ return 1;
+
+end;
+
+create function updateversion(iname varchar(10)
+ ,ii int
+ ) returns int
+begin
+
+ update version
+ set i = ii
+ where name = iname
+ ;
+
+ return 1;
+
+end;
+
+create function deleteversion(iname varchar(10)
+ ) returns int
+begin
+
+ delete
+ from version
+ where name = iname
+ ;
+
+ return 1;
+
+end;
+
+-- grant right to my_user not to my_user2
+GRANT SELECT on table version to my_user;
+GRANT INSERT on table version to my_user;
+GRANT UPDATE on table version to my_user;
+GRANT DELETE on table version to my_user;
+
diff --git a/sql/test/Users/test_privs2.sql b/sql/test/Users/test_privs2.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/test_privs2.sql
@@ -0,0 +1,16 @@
+
+SELECT * FROM version;
+
+insert into version (name ,i) values ('test2' ,2) ;
+
+SELECT insertversion('test3', 3);
+
+SELECT * FROM version;
+
+SELECT updateversion('test1', 4);
+
+SELECT * FROM version;
+
+SELECT deleteversion(4);
+
+SELECT * FROM version;
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
