chester c young wrote: > > > I could not find much documentation about SQL 92 schemas that > > > 7.3 now supports. I understood it was a structure to group various > > > objects, which allows faster privilege management, namespaces > > > definition. > > > Besides that, I don't see any advantages. I'd be glad if someone > > > could point them out for me, or give doc links. > > > > That's pretty much it. You can give each user their own namespace so > > they can all create tables with the same name, or put applications in > > their own namespace so they don't conflict with other applications. > > You can also control object creation easier by restricting privs on > > the > public namespace. > > Can you copy by schema?
No. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
