Hello everyone,
I want to give access of 1 table created by me to one of my colleagues.
To do this I have executed below statement in SPUFI to grant access to my colleague.
GRANT ALL ON TABLE SCHEMANAME.TABLENAME TO USERID1 WITH GRANT OPTION ;
Command executed successfully with return code 0 but my colleague didn't get access to the table.
Could anyone please suggest what is the problem here.
Thanks in advance.