Re: oracle database

This is pretty basic stuff, so the real advice is to do some reading.

However...

"mourad" <mouraben_at_hotmail.com> wrote in message news:89a8ff20.0205231242.7ba921c_at_posting.google.com...
> can someone please tell me :
> what is the difference between:
> -instance manage

Let's you start and stop instances, check what the init.ora parameters are set to and so on. Basic availability.

> -storage manager

Let's you see how full your data files are, add new ones

> -security manager

Let's you create new users, change the passwords of old users, lock users out, unlock accounts and so on.

> -schema manager

Let's you create tables, indexes etc. and lists them by schema (ie, by user).

> and when to use each one of them?
>

When you need to perform whatever task each tool is designed to perform.

> and also the differences between:
> -object privileges

8 privileges only, relating to performing actions on specific, named, objects. For example, to select from the emp table requires the 'select on emp' object privilege. Only the object owner, or an authorised delegate, can grant object privileges.

> -system privileges?

Around 100 privileges (98 in 8.0, 126 in 8i, 140ish in 9i) which allow you to do general things on the database. For example, being able to create a tablespace requires the 'create tablespace' system privilege. Creating a rollback segment (any rollback segment -ie, no specifics mentioned) requires 'create rollback segment' system privilege. Create table, create index, create synonym and so on: all generic system privileges, which someone with the DBA role could easily grant, or anyone who has previously been granted administration rights over a privilege.

Regards
HJR
> thank you!!
Received on Thu May 23 2002 - 16:55:00 CDT