Skip to main content
Question

How can i add DROP grant to user?

  • Nov 23, 2020 2:26 AM UTC
  • 1 reply
  • 6 views

HyeontaeJu
Forum|alt.badge.img+2

I wanna add drop grant to user, so i execute this query
ref ) this user already had other grants(SELECT, UPDATE, DELETE) ,
GRANT DROP ON schema wmp_ep_product_dev to searchop_juhyeontae;
but the user doesn't have DROP privilige...
In this case, how can i add DROP grant to user??

1 reply

HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • Nov 23, 2020 5:19 AM UTC

Ah... sorry,, i miss type the schema name haha