Re: Adding privileges to user.

From: <ajitsingh_at_hotmail.com>
Date: 1998/02/03
Message-ID: <886497437.936050692@dejanews.com>#1/1

Hi,

In Oracle, it is not possible to drop a column from a table thru a single command. Some other workarounds for achieving this are however available. b) In terms of privileges, there are broadly two types: (i) object level: like you want to give update, delete rights on a particular table to another user. e.g. grant select on emp to myuser

    grant -> command to give privilege
    select -> type of privilege
    emp -> table name
    myuser -> name of user to whom privilege is being granted.

This can be done in sqlplus after logging in as the owner of the table.

(ii) system level: privilege to carry out some tasks at the db level.

e.g. privilege to CREATE A TABLE

You can do this by connecting to system and grant the appropriate privilege.

        e.g.
        GRANT CREATE TABLE to myuser

I hope this helps. For more information, you can read Oracle documentation that comes with the trial s/w.

Ajit

In article <34D67D12.F31FBB7C_at_Videotron.Ca>, Christian Hamel <ChristianHamel_at_Videotron.Ca> wrote:
>
> <HTML>
> Hi.
> <BR>    I've downloader Personnal Oracle 7 from the Oracle
> web site (Trial version).  I wanna try it before buying it.
> <BR>I'm adding a table wich I set the owner "Christian".  I create
> a new table and add some field.  If I wanna delete a field after that,
> I can't, the option "Remove" is not available.  So I go to the Properties
> of the table and after Object Privileges.  Then I try to add some
> attributes to my user but I can't, it says "You may not GRANT/REVOKE
privileges
> from yourself".  So how can I add some privileges to "Christian" by
> logging on another user name like SYSTEM but how?  There's no login
> option at all in Oracle Navigator.  Please if you know what is my
> problem help me, I'm pretty new to Oracle.  A great tanx in advance.
>
> <P>    Christian Hamel
> <BR>    ChristianHamel_at_Videotron.Ca</HTML>

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Tue Feb 03 1998 - 00:00:00 CST