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]

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).

[Aviral-Bhardwaj]

thanks sir