Examples of org.hsqldb.rights.Grantee

org.hsqldb.rights.Grantee
A Grantee Object holds the name, access and administrative rights for a particular grantee.
It supplies the methods used to grant, revoke, test and check a grantee's access rights to other database objects. It also holds a reference to the common PUBLIC User Object, which represent the special user refered to in GRANT ... TO PUBLIC statements.
The check(), isAccessible() and getGrantedClassNames() methods check the rights granted to the PUBLIC User Object, in addition to individually granted rights, in order to decide which rights exist for the user. Method names ending in Direct indicate methods which do not recurse to look through Roles which "this" object is a member of. We use the word "Admin" (e.g., in private variable "admin" and method "isAdmin()) to mean this Grantee has admin priv by any means. We use the word "adminDirect" (e.g., in private variable "adminDirect" and method "isAdminDirect()) to mean this Grantee has admin priv directly. @author Campbell Boucher-Burnett (boucherb@users dot sourceforge.net) @author Fred Toussi (fredt@users dot sourceforge.net) @author Blaine Simpson (blaine dot simpson at admc dot com) @version 1.9.0 @since 1.8.0

        if (targetTable != null && !targetTable.isTemp()) {
            if (!session.isProcessingScript) {
                targetTable.checkDataReadOnly();
            }


            Grantee owner = targetTable.getOwner();


            if (owner != null && owner.isSystem()) {
                if (!session.getUser().isSystem()) {
                    throw Error.error(ErrorCode.X_42501,
                                      targetTable.getName().name);
                }
            }

View Full Code Here

            return t;
        }


        // Intermediate holders
        Iterator grantees;
        Grantee  grantee;
        Object[] row;


        // initialization
        grantees = session.getGrantee().visibleGrantees().iterator();


        // Do it.
        while (grantees.hasNext()) {
            grantee = (Grantee) grantees.next();
            row     = t.getEmptyRowData();
            row[0]  = grantee.getName().getNameString();
            row[1]  = grantee.isRole() ? "ROLE"
                                       : "USER";


            t.insertSys(session, store, row);
        }

View Full Code Here

        HsqlName tableName;


        // Initialization
        tables = allTables();


        Grantee grantee = session.getGrantee();


        while (tables.hasNext()) {
            table       = (Table) tables.next();
            columnCount = table.getColumnCount();
            tableName   = table.getName();


            for (int i = 0; i < columnCount; i++) {
                ColumnSchema column = table.getColumn(i);


                type = column.getDataType();


                if (!type.isDomainType()) {
                    continue;
                }


                if (!grantee.isFullyAccessibleByRole(type.getName())) {
                    continue;
                }


                row                 = t.getEmptyRowData();
                row[domain_catalog] = database.getCatalogName().name;

View Full Code Here

        HsqlName tableName;


        // Initialization
        tables = allTables();


        Grantee grantee = session.getGrantee();


        while (tables.hasNext()) {
            table       = (Table) tables.next();
            columnCount = table.getColumnCount();
            tableName   = table.getName();


            for (int i = 0; i < columnCount; i++) {
                ColumnSchema column = table.getColumn(i);


                type = column.getDataType();


                if (!type.isDistinctType()) {
                    continue;
                }


                if (!grantee.isFullyAccessibleByRole(type.getName())) {
                    continue;
                }


                row                = t.getEmptyRowData();
                row[udt_catalog]   = database.getCatalogName().name;

View Full Code Here

            return t;
        }


        // Intermediate holders
        Iterator grantees;
        Grantee  grantee;
        Object[] row;


        // initialization
        grantees = session.getGrantee().getAllRoles().iterator();


        while (grantees.hasNext()) {
            grantee = (Grantee) grantees.next();
            row     = t.getEmptyRowData();
            row[0]  = grantee.getName().getNameString();


            t.insertSys(session, store, row);
        }


        return t;

View Full Code Here

        final int privilege_type   = 8;
        final int is_grantable     = 9;


        //
        // calculated column values
        Grantee granteeObject;
        String  privilege;


        // intermediate holders
        Iterator       routines;
        Routine        routine;
        Object[]       row;
        OrderedHashSet grantees = session.getGrantee().visibleGrantees();


        routines = database.schemaManager.databaseObjectIterator(
            SchemaObject.SPECIFIC_ROUTINE);


        while (routines.hasNext()) {
            routine = (Routine) routines.next();


            for (int i = 0; i < grantees.size(); i++) {
                granteeObject = (Grantee) grantees.get(i);


                OrderedHashSet rights =
                    granteeObject.getAllDirectPrivileges(routine);
                OrderedHashSet grants =
                    granteeObject.getAllGrantedPrivileges(routine);


                if (!grants.isEmpty()) {
                    grants.addAll(rights);


                    rights = grants;

View Full Code Here

        Schema[] schemas;
        Schema   schema;
        String   dcsSchema = SqlInvariants.INFORMATION_SCHEMA;
        String   dcsName   = ValuePool.getString(Tokens.T_UTF16);
        String   sqlPath   = null;
        Grantee  user      = session.getGrantee();
        Object[] row;


        // column number mappings
        final int schema_catalog                = 0;
        final int schema_name                   = 1;
        final int schema_owner                  = 2;
        final int default_character_set_catalog = 3;
        final int default_character_set_schema  = 4;
        final int default_character_set_name    = 5;
        final int sql_path                      = 6;


        // Initialization
        schemas = database.schemaManager.getAllSchemas();


        // Do it.
        for (int i = 0; i < schemas.length; i++) {
            schema = schemas[i];


            if (!user.hasSchemaUpdateOrGrantRights(
                    schema.getName().getNameString())) {
                continue;
            }


            row                 = t.getEmptyRowData();

View Full Code Here

            if (object.getType() != SchemaObject.TYPE) {
                continue;
            }


            for (int i = 0; i < grantees.size(); i++) {
                Grantee granteeObject = (Grantee) grantees.get(i);
                OrderedHashSet rights =
                    granteeObject.getAllDirectPrivileges(object);
                OrderedHashSet grants =
                    granteeObject.getAllGrantedPrivileges(object);


                if (!grants.isEmpty()) {
                    grants.addAll(rights);


                    rights = grants;

View Full Code Here


        while (objects.hasNext()) {
            SchemaObject object = (SchemaObject) objects.next();


            for (int i = 0; i < grantees.size(); i++) {
                Grantee granteeObject = (Grantee) grantees.get(i);
                OrderedHashSet rights =
                    granteeObject.getAllDirectPrivileges(object);
                OrderedHashSet grants =
                    granteeObject.getAllGrantedPrivileges(object);


                if (!grants.isEmpty()) {
                    grants.addAll(rights);


                    rights = grants;

View Full Code Here

        }


        // Intermediate holders
        String   grantorName = SqlInvariants.SYSTEM_AUTHORIZATION_NAME;
        Iterator grantees;
        Grantee  granteeObject;
        String   granteeName;
        Iterator roles;
        String   isGrantable;
        Object[] row;


        // Column number mappings
        final int role_name    = 0;
        final int grantee      = 1;
        final int grantor      = 2;
        final int is_grantable = 3;


        // Initialization
        grantees = session.getGrantee().visibleGrantees().iterator();


        //
        while (grantees.hasNext()) {
            granteeObject = (Grantee) grantees.next();
            granteeName   = granteeObject.getName().getNameString();
            roles         = granteeObject.getDirectRoles().iterator();
            isGrantable   = granteeObject.isAdmin() ? Tokens.T_YES
                                                    : Tokens.T_NO;;


            while (roles.hasNext()) {
                Grantee role = (Grantee) roles.next();


                row               = t.getEmptyRowData();
                row[role_name]    = role.getName().getNameString();
                row[grantee]      = granteeName;
                row[grantor]      = grantorName;
                row[is_grantable] = isGrantable;


                t.insertSys(session, store, row);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.rights.Grantee

org.hsqldb.dbinfo.DatabaseInformationFull

org.hsqldb.dbinfo.DatabaseInformationMain

org.hsqldb.HsqlNameManager.HsqlName

org.hsqldb.lib.HashMap

org.hsqldb.lib.HashSet

org.hsqldb.lib.HsqlArrayList

org.hsqldb.lib.Iterator

org.hsqldb.lib.MultiValueHashMap

org.hsqldb.lib.OrderedHashSet

org.hsqldb.lib.Set

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.