Grant access to a schema

i am new to a dept and have been made owner of a schema.

i need to grant select, insert, and update privs to all objects in the schema.

how can i do and make sure they have all privs

Schema Browser > Users - double click on the user. Roles and System Privileges tabs.

From: roffdj [mailto:bounce-roffdj@toadworld.com]

Sent: Thursday, May 08, 2014 9:37 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Grant access to a schema

Grant access to a schema

Thread created by roffdj

i am new to a dept and have been made owner of a schema.

i need to grant select, insert, and update privs to all objects in the schema.

how can i do and make sure they have all privs

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.