On Mon, 03 Jan 2000, you wrote:
>
> Submit a diff to the list and I will test it on Oracle. If it works,
> we'll get it committed.
>
> -Brett
>
Hmmm... The list processor doesn't seem to like attachments, I just
got my attachment bounced. I'll include the straight diff file, hoping that my
mailer doesn't do any unwanted wrapping....
--------- cut here -----------
--- default_roles_permissions.sql.orig Tue Dec 28 05:44:40 1999
+++ default_roles_permissions.sql Mon Jan 3 20:19:59 2000
@@ -1,20 +1,20 @@
-## Script to fill the tables with default roles and permissions
-## Currently tested with MySQL only.
-## If you have access to Oracle, I'd appreciate if you could add script
-## for it.
+-- Script to fill the tables with default roles and permissions
+-- Currently tested with MySQL only.
+-- If you have access to Oracle, I'd appreciate if you could add script
+-- for it.
-## Add some default permissions
-insert into Permission (PERMISSION) values ("add_user");
-insert into Permission (PERMISSION) values ("modify_user");
-insert into Permission (PERMISSION) values ("add_group");
-insert into Permission (PERMISSION) values ("modify_group");
-insert into Permission (PERMISSION) values ("add_permission");
-insert into Permission (PERMISSION) values ("modify_permission");
+-- Add some default permissions
+insert into Permission (PERMISSION) values ('add_user');
+insert into Permission (PERMISSION) values ('modify_user');
+insert into Permission (PERMISSION) values ('add_group');
+insert into Permission (PERMISSION) values ('modify_group');
+insert into Permission (PERMISSION) values ('add_permission');
+insert into Permission (PERMISSION) values ('modify_permission');
-## Create a Role or Group in this case turbine root
-insert into UserRole (ROLENAME) values ("turbine_root");
+-- Create a Role or Group in this case turbine root
+insert into UserRole (ROLENAME) values ('turbine_root');
-## Add some permissions for turbine root
+-- Add some permissions for turbine root
insert into RolePermission (ROLEID,PERMISSIONID) select UserRole.ROLEID,
Permission.PERMISSIONID from UserRole, Permission where Permission.PERMISSION =
'add_user' and UserRole.ROLENAME = 'turbine_root';
insert into RolePermission (ROLEID,PERMISSIONID) select UserRole.ROLEID,
Permission.PERMISSIONID from UserRole, Permission where Permission.PERMISSION =
'modify_user' and UserRole.ROLENAME = 'turbine_root';
insert into RolePermission (ROLEID,PERMISSIONID) select UserRole.ROLEID,
Permission.PERMISSIONID from UserRole, Permission where Permission.PERMISSION =
'add_group' and UserRole.ROLENAME = 'turbine_root';
@@ -22,6 +22,6 @@
insert into RolePermission (ROLEID,PERMISSIONID) select UserRole.ROLEID,
Permission.PERMISSIONID from UserRole, Permission where Permission.PERMISSION =
'add_permission' and UserRole.ROLENAME = 'turbine_root';
insert into RolePermission (ROLEID,PERMISSIONID) select UserRole.ROLEID,
Permission.PERMISSIONID from UserRole, Permission where Permission.PERMISSION =
'modify_permission' and UserRole.ROLENAME = 'turbine_root';
-## Finally, add the user turbine to the turbine_root group
+-- Finally, add the user turbine to the turbine_root group
insert into VisitorRole ( VISITORID, ROLEID ) select Visitor.VISITORID,
UserRole.RoleID from Visitor, UserRole where Visitor.loginid = 'turbine' AND
UserRole.rolename = 'turbine_root';
--------- cut here -----------
--
Hakan Tandogan [EMAIL PROTECTED]
ICONSULT Tandogan - Egerer GbR Tel.: +49-9131-9047-0
Memelstrasse 38 - D-91052 Erlangen Fax.: +49-9131-9047-77
"Any sufficiently advanced bug is indistinguishable from a feature"
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
