Toad World® Forums

How to give permissions to users for a table that I created?


#1

I have created a couple of tables and I need to give some other users access to use that table - how is that done?

Message was edited by: anpki_062


#2

You need to use the GRANT syntax.

grant select, insert, update, delete on suppliers to smithj;