Dear all,
Today I grant a user all privileges to all tables in a database by
grant all privileges on svo_data_social to neha ;
grant all privileges on svo_phrases to neha ;
.. . .....
.....
...
Now i find it very uncomfort to grant privileges one by one table.
Is there a simple way to grant privileges on all tables, views,
sequences etc in a database.
Also , after granting all privileges , rename command is not granted.
Is it impossible to grant alter & drop privileges to user which is
granted to only the user who created the object.
What is ALL privileges comprised of ?
Thanks