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

[seberino]

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.

[Geeta1]

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

[seberino]

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

[Vartika]

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!