Grant on table fails

[mike...@gmail.com]

Creating a table and granting all to public fails.
When I create a table in isql and grant all on the table to public, no other user can see the table.
Example
1> create table mikes (col1 varchar(10))


2> grant all on mikes to public


3> commit


End of Request

However logging in as a different user I get
1> select * from mikes

E_US0845 Table 'mikes' does not exist or is not owned by you.
(Wed Jun 19 10:39:44 2013)


End of Request - Terminated by Errors

Running Ingres SPARC SOLARIS Version II 9.2.1 (su9.us5/103)

We are doing the same thing in OpenRoad5.1 and getting the same issue.

Is this a known issue and is there a patch?

[Martin Bowes]

Hi Mike.

The new user must specify a schema name in the table.

Ie. Who owns the table.

When a user selects from a table and no schema is supplied then the system will search the schema of the user, then the schema of the database owner...and no one else.

Marty

_______________________________________________
Info-Ingres mailing list
Info-...@kettleriverconsulting.com
http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres

[mike...@gmail.com]

Thanks for that. A schoolboy error!