grant select,insert update,delete on tabs on HDR
Hi All, Just a question regarding granting access to a user on HDR. I did the ff: 1. grant connect to username; 2. grant connect,insert, delete, update on table as owner. Question, Will the HDR (secondary) automatically sync what i have done on primary? Kindly let me know if i need to do anything on HDR (secondary server). As i know it should not be created on secondary anymore as Primary will sync automatically on Secondary.
FYI, you should always post your version and platform information. If the database is logged then the grants will be applied on the secondary as well. No problem. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Nov 4, 2009 at 1:41 AM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > Just a question regarding granting access to a user on HDR. I did the ff: > > 1. grant connect to username; > 2. grant connect,insert, delete, update on table as owner. > > Question, > > Will the HDR (secondary) automatically sync what i have done on primary? > > Kindly let me know if i need to do anything on HDR (secondary server). As i > know it should not be created on secondary anymore as Primary will sync > automatically on Secondary. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174bdcc86663b2047789df46
One common problem may be forget to create the user/passwd on the secondary server. Jairo Art Kagel escreveu: FYI, you should always post your version and platform information. If the database is logged then the grants will be applied on the secondary as well. No problem. Art Art S. Kagel Oninit ([1]www.oninit.com) IIUG Board of Directors ([2]art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Nov 4, 2009 at 1:41 AM, JACK PAPA [3]<informix2009@gmail.com> wrote: Hi All, Just a question regarding granting access to a user on HDR. I did the ff: 1. grant connect to username; 2. grant connect,insert, delete, update on table as owner. Question, Will the HDR (secondary) automatically sync what i have done on primary? Kindly let me know if i need to do anything on HDR (secondary server). As i know it should not be created on secondary anymore as Primary will sync automatically on Secondary. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --0015174bdcc86663b2047789df46 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. . References 1. http://www.oninit.com/ 2. mailto:art@iiug.org 3. mailto:informix2009@gmail.com
Yes = From: "JACK PAPA" <informix2009@gmail.com> = = To: ids@iiug.org = = Date: 11/04/2009 12:42 AM = = Subject: grant select,insert update,delete on tabs on HDR [17896]= = Sent by: ids-bounces@iiug.org = = Hi All, Just a question regarding granting access to a user on HDR. I did the f= f: 1. grant connect to username; 2. grant connect,insert, delete, update on table as owner. Question, Will the HDR (secondary) automatically sync what i have done on primary= ? Kindly let me know if i need to do anything on HDR (secondary server). = As i know it should not be created on secondary anymore as Primary will sync= automatically on Secondary. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Thanks all. BTW, i'm using IDS 9.4 on AIX 5.