hi all,

i am learning oracle applications now,

for example , we have 10 users
i want to add sysadmin responsibility to 5 users (query only mode ) and also give full access permission to another 3 users. how can i give query only permission to users.

Any help will be appreciated.