Examples with GrantOnStep org.jooq.GrantOnStep used on opensource projects

Example 1 with GrantOnStep

use of org.jooq.GrantOnStep in project jOOQ by jOOQ.

the class DefaultParseContext method parseGrant.

private final DDLQuery parseGrant() {
    parseKeyword("GRANT");
    Privilege privilege = parsePrivilege();
    List<Privilege> privileges = null;
    while (parseIf(',')) {
        if (privileges == null) {
            privileges = new ArrayList<>();
            privileges.add(privilege);
        }
        privileges.add(parsePrivilege());
    }
    parseKeyword("ON");
    parseKeywordIf("TABLE");
    Table<?> table = parseTableName();
    parseKeyword("TO");
    User user = parseKeywordIf("PUBLIC") ? null : parseUser();
    GrantOnStep s1 = privileges == null ? dsl.grant(privilege) : dsl.grant(privileges);
    GrantToStep s2 = s1.on(table);
    GrantWithGrantOptionStep s3 = user == null ? s2.toPublic() : s2.to(user);
    return parseKeywordIf("WITH GRANT OPTION") ? s3.withGrantOption() : s3;
}