Thread: Roles and privileges?
Greetings one and all, I've been working a lot with roles and privileges lately. I have some developers which I would like to give just temporary access to make tables and so on in databases. There is a "temporary" privilege that can be granted to a database. Does this work this way, or does a user have to have the ability to the create option specified on the user's role? Is there a query I can run to find out which users have which roles? What does the "references" privilege do? Can I grant privileges on views to users just as I do on tables, or does having privileges to the underlying tables take care of that. I've gotten errors in the past when I've tried to grant privs on views, but I've done an upgrade since then. I'm now on 8.2.3. Thanks, Carol
I am trying to do a PITR. I have seen posts about dumping from a 32 bit to 64 bit. But, I have not seen anything about dumping from 64 bit to 32 bit. Could that cause a checksum error?
FATAL: incorrect checksum in control file
Main database server (64 bit): Linux server1 2.6.5-7.282-smp #1 SMP Tue Aug 29 10:40:40 UTC 2006 x86_64 x86_64 x86_64 GNU/Linux
Backup database server (32 bit): Linux server2 2.6.5-7.282-bigsmp #1 SMP Tue Aug 29 10:40:40 UTC 2006 i686 i686 i386 GNU/Linux
|