Oracle Spatial is installed under the MDSYS user account.
MDSYS is a high privilege account with rights similar to the system accounts. The user account is locked by default on more recent versions of Oracle. If your MDSYS user account is unlocked, lock it immediately, you should never need to login as MDSYS, even to create data.
MDSYS has rights with admin option so it can in turn grant rights to other users.
MDSYS is the owner of all the spatial objects, types, metadata, functions, packages and procedures.
If you have installed locator then the MDSYS schema will contain fewer objects than the full spatial option.
Remember, spatial is a licenceable option. Contact Oracle for pricing in your region.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment