- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2024 07:31 AM
I transfered the owner of pre-created datasets (catalogs and schemas) by workspace admin to a service principle.
I think as the owner, the job owned by `sp`, should be able to create table in all schemas under catalog xyz. however I got the error: PERMISSION_DENIED, user do not have CREATE TABLE....
My question is the owner of catalog does not propagate to schema and table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2024 08:48 AM - edited 12-04-2024 08:48 AM
Hi @hdu ,
Below is an excerpt from documentation:
"Owners of an object are automatically granted all privileges on that object. In addition, object owners can grant privileges on the object itself and on all of its child objects. This means that owners of a schema do not automatically have all privileges on the tables in the schema, but they can grant themselves privileges on the tables in the schema."
So as an owner you have ability to grant yourself required permission, but you don't have them granted automatically.
