Re: [SQL] What benefits can I expect from schemas ?
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
Re: [SQL] What benefits can I expect from schemas ?
> > 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 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [SQL] What benefits can I expect from schemas ?
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 [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 6: Have you searched our list archives? http://archives.postgresql.org
[SQL] 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 ---(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