Thread: What benefits can I expect from schemas ?
Hi, I could not find much documentation about SQL 92 schemas that version 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. Thanks. _____________________________________________________________________ GRAND JEU SMS : Pour gagner un NOKIA 7650, envoyez le mot IF au 61321 (prix d'un SMS + 0.35 euro). Un SMS vous dira si vous avez gagné. Règlement : http://www.ifrance.com/_reloc/sign.sms
Bob Lapique wrote: > Hi, > > I could not find much documentation about SQL 92 schemas that version > 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. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
> > 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? __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
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 pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073