how to provide access to other users for the table?

nandeshwar · New User Joined: 11 Oct 2010 Posts: 45 Location: Delhi

hi
can somebody tel me what is the command for providing access to my tables for other users.

i am using :
GRANT ALL ACCESS ON (userid.table name) TO PUBLIC

but this command is not working.

ofer71 · Posted: Tue Dec 14, 2010 12:31 pm

What do you mean by "not working"?

O.

ssmukul · New User Joined: 22 Jan 2008 Posts: 19 Location: India

Hi Nandeshwar,

Please try to run the Grant query without ACCESS keyword.

i.e.
GRANT ALL ON (Table name) TO PUBLIC.

Thanks,

nandeshwar · New User Joined: 11 Oct 2010 Posts: 45 Location: Delhi

GuyC · Posted: Tue Dec 14, 2010 4:42 pm

don't run it as a QMF command, put it in a query and run it.

and no need to grant all.
"grant select on table xxxxx " might be sufficient.

nandeshwar · New User Joined: 11 Oct 2010 Posts: 45 Location: Delhi