Re: Adding privileges to user.

Hi Christian,

You cannot remove a column from an existing table in Oracle.

There are two ways around the problem:

1. Drop the table and recreate it without the column you want to remove.
2. Create a view of the table that does not include the column that you want to remove.

Of course you can always ignore the presence of the column.

Regards

Jerry

Christian Hamel wrote:
>
> Hi.
> I've downloader Personnal Oracle 7 from the Oracle web site (Trial
> version). I wanna try it before buying it.
> 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.
>
> Christian Hamel
> ChristianHamel_at_Videotron.Ca
Received on Mon Feb 02 1998 - 00:00:00 CST