How prevent users from being able to create NEW databases? Possible without Unity Catalog?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2022 06:43 AM
How prevent users from being able to create NEW databases? Possible without Unity Catalog?
I'm working on access control and I know how to remove select and modify privileges on schemas and tables but that's it.
- Labels:
-
Unity Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2022 08:44 AM
Hi @Christian Seberino , I think you can assign the users with Database owner or Table owner roles.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2022 08:52 AM
Geeta
Thanks. I discovered what I think is the correct syntax to revoke privileges to the catalog..
revoke privilege to catalog catalog-name from user-name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2022 03:28 AM
Hi @Christian Seberino,
Hope everything is going great.
Thank you for reaching out to the community with your question. Would you be happy to mark an answer as best so that other members can find the solution more quickly?
Cheers!