On Wednesday 22 October 2003 17:11, Birahim FALL wrote: > Thanks, Shridhar, > I've read something like that in my search this morning! > But doing that you can have only one package in the scope of a schema. > Then in a multipackage project these packages cannot access directly to > the same objects. > In you eg. We could have a table a.people, and it is not in a scope > accessible to b.test1 without a grant statement.
Yes that is correct. In fact you could look at it as additional security feature. i.e. functions from a package can only be accessed by a certain users..:-) Besides there is only one grant you need per schema, that is usage. Shouldn't be a such a big problem, isn't it? I would be surprised if oracle packages did not provide this feature. > More info is welcomed, Check schema search path http://developer.postgresql.org/docs/postgres/sql-set.html I just checked if I could create nested schemas. That would be way too cool.. but it is not supported..:-( HTH Shridhar ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
