Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to grant me permissions to my own tables ?
Well - finally found out the problem ... it wasn't a permissions problem at all.
Just a stupid behaviour of SQLPlus - that I am now aware of.
In my 15 years of programming and databasing, I had never come across a language that doesn't PRESERVE case, but RESPECTS it. I have been doing SQL for around 10 years, MS-SQL solidly for 3 years - and now I get a chance to work with a real DB, I am finding that programming, database development and the like have so far taken less than 20% of my time. The other 80% seems to be ironing out quirks in the system, quirks possibly preserved through time since version 1.
In Pascal - the idenitifier Fred = FRED = FreD, that is it doesn't respect case, but does preserve it. In C - the identifier Fred <> FRED <> FreD, that is it DOES respect case - AND it preserves it. In earlier BASICs - the identifer Fred gets changed to FRED, that is it doesn't respect OR preserve case.
In Oracle (with a table called Fred - note the case).
select * from Fred
it first uppercases the Fred -> FRED
then has the hide to tell me it cannot find FRED.
So it looks like I'll be using alot of quotes from now one.
Grrrr
In article <8mdsst$9bf$1_at_nnrp1.deja.com>, tjmxyz_at_my-deja.com wrote:
> 1 Log in as the user you created the tables as ccburke.
> The type: grant select,update,delete,insert on tablename to CCBURKE;
>
> It is a little strange. Because as the user creating the tables you
> should have permission to do this already.
>
> Check in DBA Studio for the "owner" beacuse
>
> Or do Select owner from dba_tables where table_name='tablename';
>
> Just to verify the table where created under the user you thought they
> were.
>
> HTH In article <8mdm3j$odf$1_at_bunyip.cc.uq.edu.au>,
> "Christopher Burke" <craznar_at_hotmail.com> wrote:
>> I created and filled a set of tables in Tablespace "CCBURKE" on an
Oracle
>> Server 8.0.6 on Solaris. >> >> Problem is that I don't have any permissions to the tables - how do Igive
>> myself permissions to read the tables. >> >> They are mine logging in as CCBURKE with the password works fine, but >> select * from CCBURKE.tablename returns a no such table error. >> >> CCBURKE is the user that created and filled the tables. >> >> I used an ODBC client to import the tables, the tables are actuallythere
>> (I can see them in the GUI DBA Studio program). >> >> Help please. >> >>