How to grant user access to additional tablespaces in Oracle?
I want to know How to grant user access to additional tablespaces in Oracle? , because I have 开发者_如何学编程created two additional tablespaces, one for data and the other for indexes, like this discussion said:
Tablespaces in Oracle
I’m doing it for performance.
The old way was to grant quota on tablespacename to username
, which allowed users to create objects on that tablespace. You can still do it that way, but there is a more current method (which I cannot recall at the moment).
精彩评论