Hello,
Assuming I have 5 applications that are in 5 different tablespaces. And there are about 100 users using the database.
After creating these 100 users, what is the best way to give the users access to the tablespaces that they are not supposed to have access to and also what is the best way to give users access to to tablespaces that they are supposed to have access to?
i.e. to give permission to users of one tablespace and deny them permission to the other tablespace. So that certain users can see the contents of some tablespaces while other user can see the contents of other tablespace.

thanks,
dorothy