Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> oracle grants/roles v sql server
Hi. I want to grant a user read (select) access to all objects in a schema
in Oracle. In sql server, I would just give the user a db_datareader role
for that schema. How is that done in Oracle? I don't want to give access
on an object-by-object basis one at a time, in case new objects are created
afterwards.
Received on Mon Jul 24 2006 - 08:17:47 CDT
![]() |
![]() |