Voordat u de toegang voor de database wilt toekennen dient u ervoor te zorgen dat de gebruiker is aangemaakt. U kunt de instructies op deze pagina volgen om database gebruikers aan te maken
Volg de onderstaande stappen om de toegang te herstellen. Start fenixsql op en voer onderstaande code uit
Toegang tot alle tabellen:
EXECUTE BLOCK
AS
DECLARE VARIABLE tablename VARCHAR(32);
BEGIN
FOR SELECT rdb$relation_name
FROM rdb$relations
WHERE rdb$view_blr IS NULL
AND (rdb$system_flag IS NULL OR rdb$system_flag = 0)
and rdb$relation_name != ‘TRAIL_LOG’
INTO :tablename DO
BEGIN
EXECUTE STATEMENT (‘GRANT SELECT ON TABLE ‘ || :tablename || ‘ TO USER KASSA’);
EXECUTE STATEMENT (‘GRANT UPDATE ON TABLE ‘ || :tablename || ‘ TO USER KASSA’);
EXECUTE STATEMENT (‘GRANT DELETE ON TABLE ‘ || :tablename || ‘ TO USER KASSA’);
EXECUTE STATEMENT (‘GRANT INSERT ON TABLE ‘ || :tablename || ‘ TO USER KASSA’);
END
END
vervolgens voer de onderstaande code uit:
EXECUTE BLOCK
AS
DECLARE VARIABLE tablename VARCHAR(32);
BEGIN
FOR SELECT rdb$relation_name
FROM rdb$relations
WHERE rdb$view_blr IS NULL
AND (rdb$system_flag IS NULL OR rdb$system_flag = 0)
and rdb$relation_name = ‘TRAIL_LOG’
INTO :tablename DO
BEGIN
EXECUTE STATEMENT (‘GRANT SELECT ON TABLE ‘ || :tablename || ‘ TO USER KASSA’);
END
END
Toegang tot views
EXECUTE BLOCK
AS
DECLARE VARIABLE tablename VARCHAR(32);
BEGIN
FOR SELECT rdb$relation_name
FROM rdb$relations
where rdb$view_blr is not null
and (rdb$system_flag is null or rdb$system_flag = 0)
INTO :tablename DO
BEGIN
EXECUTE STATEMENT (‘GRANT SELECT ON TABLE ‘ || :tablename || ‘ TO USER KASSA’);
END
END
Toegang tot procedures
EXECUTE BLOCK
AS
DECLARE VARIABLE tablename VARCHAR(32);
BEGIN
FOR
SELECT rdb$Procedure_name
FROM rdb$procedures
WHERE rdb$system_flag IS NULL OR rdb$system_flag = 0
INTO :tablename DO
BEGIN
EXECUTE STATEMENT (‘GRANT EXECUTE ON PROCEDURE ‘ || :tablename || ‘ TO USER KASSA’);
END
END
.
