-- DBA create the database and give access permissions.
--
-- $Log: create.sql,v $
--- Revision 1.15 2003-08-05 07:43:24 arjen
+-- Revision 1.16 2003-08-16 14:29:02 arjen
+-- Fixed a few typos.
+--
+-- Revision 1.15 2003/08/05 07:43:24 arjen
-- Added index to the history table.
--
-- Revision 1.14 2003/07/09 07:14:59 arjen
checkid BIGINT,
sortorder INTEGER,
last_logid BIGINT default 0,
- historicboundary INTERVAL default 0,
+ historicboundary INTERVAL default '0',
use_logid BOOLEAN default false,
sql_query TEXT
);
GRANT INSERT ON action_user TO GROUP ops, GROUP admin;
GRANT UPDATE ON notification TO GROUP ops, GROUP admin;
-GRANT INSERT ON object GROUP admin;
+GRANT INSERT ON object TO GROUP admin;
GRANT UPDATE ON object TO GROUP ops, GROUP admin;
-GRANT DELETE ON object GROUP admin;
+GRANT DELETE ON object TO GROUP admin;
GRANT UPDATE ON usr TO GROUP view, GROUP ops, GROUP admin;
GRANT INSERT ON usr TO GROUP admin;
GRANT DELETE ON usr TO GROUP admin;