topic Re: How prevent users from being able to create NEW databases? Possible without Unity Catalog? in Data Governance

How prevent users from being able to create NEW databases? Possible without Unity Catalog?

seberino — Tue, 13 Dec 2022 14:43:10 GMT

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.

Re: How prevent users from being able to create NEW databases? Possible without Unity Catalog?

Geeta1 — Tue, 13 Dec 2022 16:44:57 GMT

Hi @Christian Seberino , I think you can assign the users with Database owner or Table owner roles.

Re: How prevent users from being able to create NEW databases? Possible without Unity Catalog?

seberino — Tue, 13 Dec 2022 16:52:47 GMT

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

Re: How prevent users from being able to create NEW databases? Possible without Unity Catalog?

Vartika — Wed, 14 Dec 2022 11:28:03 GMT

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!