Administration.

From: Markus Gronotte <maqqusz_at_gmx.de>
Date: Mon, 1 Jun 2009 15:03:59 +0200
Message-ID: <4a23d1c9$0$31336$9b4e6d93_at_newsspool4.arcor-online.net>

I do this Code as System:

Create Table T_Controlling (

   ControllingID number,
   Mitarbeiter number,
   Verkaeufe number,
   Constraint PK_Control Primary Key (ControllingID),    Constraint FK_Control Foreign Key (Mitarbeiter) References Mitarbeiter(MitarbeiterID) );

Create Role R_Einkauf
Create Role R_Verkauf

Grant Connect to R_Einkauf
Grant Connect to R_Verkauf

Grant Select On T_Controlling to R_Einkauf Grant Select On T_Controlling to R_Verkauf

Grant Insert On T_Controlling to R_Einkauf Grant Insert On T_Controlling to R_Verkauf

Grant Update On T_Controlling to R_Einkauf Grant Update On T_Controlling to R_Verkauf

Grant Select On T_Mitarbeiter to R_Einkauf Grant Select On T_Mitarbeiter to R_Verkauf

Grant Select On T_Waren to R_Einkauf
Grant Select On T_Lieferanten to R_Einkauf

Grant Select On T_Rechnung to R_Verkauf
Grant Select On T_Kunden to R_Verkauf

Create User Meyer   Identified By "abc" 
Create User Moeller Identified By "abc" 
Create User Mueller Identified By "abc" 
Create User Schmidt Identified By "abc" 



Grant R_Einkauf to Meyer
Grant R_Einkauf to Moeller 

Grant R_Verkauf to Mueller
Grant R_Verkauf to Schmidt

Then I log in with "Schmidt" and if i try to do select * from T_Controlling Oracle says "ORA-00942: Table or View not found.

Does anybody know why?

Yours,
Markus Received on Mon Jun 01 2009 - 08:03:59 CDT