List Info

Thread: Problem creating schema
Problem creating schema
country flaguser name
United States		 2007-06-13 12:16:30 

  


  

    

I am trying to create a schema for an existing 
database with an 


existing table named EMPLOYEES. The purpose is for 
the "PEN" 


branch manager to be able to see his employees only 
and not 


those from the other branches. I enter the 
following through the 


DBManager.


 


CREATE SCHEMA PEN AUTHORIZATION DBA


CREATE VIEW PENEMPLOYEES AS SELECT * FROM 



EMPLOYEES WHERE BRANCH='PEN';


 


and it returns the following error.


 


Table not found in statement [SELECT * FROM 
EMPLOYEES]


 


What am I doing wrong please? The documentation is 
not much 


help here.


 


Bayless

  

  
  
   
     
    

  

    Re:  Problem creating schema
  


  

     country flaguser name
United Kingdom		
     2007-06-13 13:10:53
  


  

    

  


  

    

In 1.8.0, views cannot reference other schemas (the next 
version will support this). 


 


You should be able to achieve this by creating the view in the 
same schema and granting SELECT on the view to a non-admin user.


 


Fred



  
----- Original Message ----- 

  
  
  
Sent: 13 June 2007 18:16

  
Subject: [Hsqldb-user] Problem creating 
  schema

  


  
I am trying to create a schema for an existing 
  database with an 

  
existing table named EMPLOYEES. The purpose is 
  for the "PEN" 

  
branch manager to be able to see his employees 
  only and not 

  
those from the other branches. I enter the 
  following through the 

  
DBManager.

  
 

  
CREATE SCHEMA PEN AUTHORIZATION DBA

  
CREATE VIEW PENEMPLOYEES AS SELECT * FROM 
  

  
EMPLOYEES WHERE BRANCH='PEN';

  
 

  
and it returns the following error.

  
 

  
Table not found in statement [SELECT * FROM 
  EMPLOYEES]

  
 

  
What am I doing wrong please? The documentation 
  is not much 

  
help here.

  
 

  
Bayless


  

  


  
-------------------------------------------------------------------------
This 
  SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE 
  version of DB2 express and take
control of your XML. No limits. Just data. 
  Click to get it now.
http://sourceforge.net/powerbar/db2/
  

  


  
_______________________________________________
Hsqldb-user mailing 
  list
Hsqldb-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

  

  
  
   
     
    

  

    Re:  Problem creating schema
  


  

     country flaguser name
United States		
     2007-06-14 07:39:31
  


  

    

  


  

    

Thanks Fred. I have never dealt with schemas before 
and just assumed it was something I was doing wrong. Any guess when 1.8.0 will 
be available?


 


Bayless



 



  
----- Original Message ----- 

  
  
  
Sent: Wednesday, June 13, 2007 1:10 
  PM

  
Subject: Re: [Hsqldb-user] Problem 
  creating schema

  


  
In 1.8.0, views cannot reference other schemas (the next 
  version will support this). 

  
 

  
You should be able to achieve this by creating the view in 
  the same schema and granting SELECT on the view to a non-admin user.

  
 

  
Fred

  

    
----- Original Message ----- 

    
    
    
Sent: 13 June 2007 18:16

    
Subject: [Hsqldb-user] Problem creating 
    schema

    


    
I am trying to create a schema for an existing 
    database with an 

    
existing table named EMPLOYEES. The purpose is 
    for the "PEN" 

    
branch manager to be able to see his employees 
    only and not 

    
those from the other branches. I enter the 
    following through the 

    
DBManager.

    
 

    
CREATE SCHEMA PEN AUTHORIZATION 
DBA

    
CREATE VIEW PENEMPLOYEES AS SELECT * FROM 
    

    
EMPLOYEES WHERE BRANCH='PEN';

    
 

    
and it returns the following 
error.

    
 

    
Table not found in statement [SELECT * FROM 
    EMPLOYEES]

    
 

    
What am I doing wrong please? The documentation 
    is not much 

    
help here.

    
 

    
Bayless


    

    


    
-------------------------------------------------------------------------
This 
    SF.net email is sponsored by DB2 Express
Download DB2 Express C - the 
    FREE version of DB2 express and take
control of your XML. No limits. Just 
    data. Click to get it now.
http://sourceforge.net/powerbar/db2/ 
    

    


    
_______________________________________________
Hsqldb-user 
    mailing 
    list
Hsqldb-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

  

  


  
-------------------------------------------------------------------------
This 
  SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE 
  version of DB2 express and take
control of your XML. No limits. Just data. 
  Click to get it now.
http://sourceforge.net/powerbar/db2/
  

  


  
_______________________________________________
Hsqldb-user mailing 
  list
Hsqldb-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

  

  


  
No virus found in this incoming message.
Checked by AVG Free 
  Edition. 
Version: 7.5.472 / Virus Database: 269.8.15/847 - Release Date: 
  6/12/2007 9:42 PM

  

  
  
   
     
    

  

    Re:  Problem creating schema
  


  

     country flaguser name
United Kingdom		
     2007-06-14 08:04:49
  


  

    

  


  

    

No estimate, as we have been adding more and more features 
since last year.


 


For your usage, it is actually better to define the views in 
the same schema. It is database object access rights (GRANT and REVOKE) that you 
should concentrate on. And HSQLDB is pretty strong here


 


Fred.


 



  
----- Original Message ----- 

  
  
  
Sent: 14 June 2007 13:39

  
Subject: Re: [Hsqldb-user] Problem 
  creating schema

  


  
Thanks Fred. I have never dealt with schemas 
  before and just assumed it was something I was doing wrong. Any guess when 
  1.8.0 will be available?

  
 

  
Bayless


  
 

  

    
----- Original Message ----- 

    
    
    
Sent: Wednesday, June 13, 2007 1:10 
    PM

    
Subject: Re: [Hsqldb-user] Problem 
    creating schema

    


    
In 1.8.0, views cannot reference other schemas (the next 
    version will support this). 

    
 

    
You should be able to achieve this by creating the view in 
    the same schema and granting SELECT on the view to a non-admin user.

    
 

    
Fred

    

      
----- Original Message ----- 

      
      
      
Sent: 13 June 2007 18:16

      
Subject: [Hsqldb-user] Problem 
      creating schema

      


      
I am trying to create a schema for an 
      existing database with an 

      
existing table named EMPLOYEES. The purpose 
      is for the "PEN" 

      
branch manager to be able to see his 
      employees only and not 

      
those from the other branches. I enter the 
      following through the 

      
DBManager.

      
 

      
CREATE SCHEMA PEN AUTHORIZATION 
      DBA

      
CREATE VIEW PENEMPLOYEES AS SELECT * FROM 
      

      
EMPLOYEES WHERE BRANCH='PEN';

      
 

      
and it returns the following 
      error.

      
 

      
Table not found in statement [SELECT * FROM 
      EMPLOYEES]

      
 

      
What am I doing wrong please? The 
      documentation is not much 

      
help here.

      
 

      
Bayless


      

      


      
-------------------------------------------------------------------------
This 
      SF.net email is sponsored by DB2 Express
Download DB2 Express C - the 
      FREE version of DB2 express and take
control of your XML. No limits. 
      Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/ 
      

      


      
_______________________________________________
Hsqldb-user 
      mailing 
      list
Hsqldb-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

    

    


    
-------------------------------------------------------------------------
This 
    SF.net email is sponsored by DB2 Express
Download DB2 Express C - the 
    FREE version of DB2 express and take
control of your XML. No limits. Just 
    data. Click to get it now.
http://sourceforge.net/powerbar/db2/ 
    

    


    
_______________________________________________
Hsqldb-user 
    mailing 
    list
Hsqldb-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

    

    


    
No virus found in this incoming message.
Checked by AVG Free 
    Edition. 
Version: 7.5.472 / Virus Database: 269.8.15/847 - Release Date: 
    6/12/2007 9:42 PM

  

  


  
-------------------------------------------------------------------------
This 
  SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE 
  version of DB2 express and take
control of your XML. No limits. Just data. 
  Click to get it now.
http://sourceforge.net/powerbar/db2/
  

  


  
_______________________________________________
Hsqldb-user mailing 
  list
Hsqldb-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

  

  
  
   
     
    






 [1-4]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )