Hi, i' ve have this problem:

I make an object under schema. And now, with sqlid = schema_name i wnat make grant

grant select, update,delete on table schema_name.table_name to user.

But i receive this error : schema_name does not have privileges to perform operation grant operation on table_name.

How can it is possible, that i can grant under schema ????

Thanks

Views: 10

Reply to This

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

Posted by Paul McWilliams on May 22, 2018 at 21:25 0 Comments

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in…

Continue

Videos

  • Add Videos
  • View All

PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service