Update of /cvsroot/monetdb/sql/src/test/Users
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv6989/src/test/Users
Added Files:
role.sql schema.sql table.sql
Log Message:
propagated changes of Friday Mar 16 2007 - Thursday Mar 22 2007
from the SQL_2-16 branch to the development trunk
--- NEW FILE: schema.sql ---
CREATE ROLE my_role;
CREATE SCHEMA my_schema AUTHORIZATION my_role;
CREATE USER my_user with password 'p1' name 'User with role' schema "my_schema";
-- grant role to user my_user
GRANT my_owner to my_user; -- error wrong non existing role
GRANT my_role to my_user;
CREATE USER my_user2 with password 'p2' name 'User without role' schema
"my_schema";
--- NEW FILE: role.sql ---
SET ROLE my_role;
--- NEW FILE: table.sql ---
SET ROLE my_role;
CREATE TABLE my_schema.my_table (
obsid INT NOT NULL AUTO_INCREMENT,
time_s BIGINT NULL,
time_e BIGINT NULL,
PRIMARY KEY (obsid)
);
INSERT INTO my_schema.my_table (time_s) values (300);
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
