Skip to main content
Question

How can i add DROP grant to user?

  • November 23, 2020
  • 1 reply
  • 3 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
  • November 23, 2020

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