s filexml="privsys.ddl"
d $SYSTEM.SQL.DDLImport("CACHE",$USERNAME,filexml)

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- Cachй SQL DDL Export
-- File: privsys.ddl
-- Date: 24 april 2007
-- Export of: USERS ROLES PRIVILEGES
-- From Namespace: RSPU
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- Export of all User definitions --

SET OPTION SUPPORT_DELIMITED_IDENTIFIERS = TRUE
go

SETUSER SUPERUSER
go

GRANT SELECT ON %SYS.Audit TO secadmin
go

GRANT SELECT ON %SYS_Task.History TO secadmin
go

GRANT SELECT ON Security.Roles TO secadmin
go

GRANT SELECT ON Security.Users TO secadmin
go

GRANT SELECT ON Security.Applications TO secadm
go

GRANT SELECT ON Security.Domains TO secadm
go

GRANT SELECT ON Security.Events TO secadm
go

GRANT SELECT ON Security.Resource TO secadm
go

GRANT SELECT ON Security.Resources TO secadm
go

GRANT SELECT ON Security.Roles TO secadm
go

GRANT SELECT ON Security.Services TO secadm
go

GRANT SELECT ON Security.System TO secadm
go

GRANT SELECT ON Security.Users TO secadm
go

DELETE FROM Security.Users WHERE ID='_public'
go

DELETE FROM Security.Users WHERE ID='unknownuser'
go