PrivilegesSELECT: gives read access to an object.CREATE: gives ability to create an object (for example, a table in a schema).MODIFY: gives ability to...

Rishabh-Pandey — Tue, 27 Dec 2022 11:42:22 GMT

Privileges

SELECT
: gives read access to an object.
CREATE
: gives ability to create an object (for example, a table in a schema).
MODIFY
: gives ability to add, delete, and modify data to or from an object.
USAGE
: does not give any abilities, but is an additional requirement to perform any action on a schema object.
READ_METADATA
: gives ability to view an object and its metadata.
CREATE_NAMED_FUNCTION
: gives ability to create a named UDF in an existing catalog or schema.
MODIFY_CLASSPATH
: gives ability to add files to the Spark class path.
ALL PRIVILEGES
: gives all privileges (is translated into all the above privileges).

Re: PrivilegesSELECT: gives read access to an object.CREATE: gives ability to create an object (for example, a table in a schema).MODIFY: gives ability to...

Aviral-Bhardwaj — Wed, 28 Dec 2022 04:40:33 GMT

thanks sir