Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to Configure User Access to update tables.

12 posts in General Discussion Last posting was on 2003-05-28 20:18:41.0Z
Richard Posted on 2003-05-20 13:25:53.0Z
From: Richard
Date: Tue, 20 May 2003 09:25:53 -0400
Newsgroups: ianywhere.public.general
Subject: How to Configure User Access to update tables.
Message-ID: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums>
Lines: 15
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1041
Article PK: 2998

I have a database where I have created Tables, Views, Stored Procedures,
The owner of the database objects is DBA and my user is granted execute on
the Stored Procedure, Views but no access through tables. I do not want to
give the user Table access directly. Everything works great except I have
a Disconnected Recordset that uses the View and is unable to update the
underlying Table. The message is:
[Sybase][ODBC Driver][Adaptive Server Anywhere]Syntax error or access
violation: Permission denied: you do not have permission to update
"MYTABLE"

Note:This will work once I give the User Table access.

How can I achieve this without Direct Table access.

Thanks!
Richard


Robert Waywell Posted on 2003-05-20 20:02:00.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums>
Subject: Re: How to Configure User Access to update tables.
Date: Tue, 20 May 2003 16:02:00 -0400
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#NXuRuwHDHA.277@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1047
Article PK: 3006

Check this section of the docs for a detailed discussion on permissions and
views:

Adaptive Server Anywhere Database Administration Guide
12. Managing User IDs and Permissions
Managing individual user IDs and permissions

Granting permissions on views

As long as you GRANT UPDATE on the view to the user then they should be
able to perform updates through the view without having UPDATE permission on
the base table. This does assume that the view is updateable in itself.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Richard> wrote in message
news:628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums...
> I have a database where I have created Tables, Views, Stored Procedures,
> The owner of the database objects is DBA and my user is granted execute on
> the Stored Procedure, Views but no access through tables. I do not want
to
> give the user Table access directly. Everything works great except I have
> a Disconnected Recordset that uses the View and is unable to update the
> underlying Table. The message is:
> [Sybase][ODBC Driver][Adaptive Server Anywhere]Syntax error or access
> violation: Permission denied: you do not have permission to update
> "MYTABLE"
>
> Note:This will work once I give the User Table access.
>
> How can I achieve this without Direct Table access.
>
> Thanks!
> Richard


Richard Posted on 2003-05-20 22:24:49.0Z
From: Richard
Date: Tue, 20 May 2003 18:24:49 -0400
Newsgroups: ianywhere.public.general
Subject: Re: How to Configure User Access to update tables.
Message-ID: <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub>
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1048
Article PK: 3007

Thanks for your response...
I do have a group that has GRANT Update access to the View and it still
gives me the ERROR I also tried Granting the user access to the View and it
didn't work either and lastly The View is updateable...

Any other Ideas?

Richard


Robert Waywell Posted on 2003-05-21 16:40:23.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub> <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums>
Subject: Re: How to Configure User Access to update tables.
Date: Wed, 21 May 2003 12:40:23 -0400
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#CUrSi7HDHA.253@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1051
Article PK: 3005

Did you want to post the SQL statements you used?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Richard> wrote in message
news:AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums...
> Thanks for your response...
> I do have a group that has GRANT Update access to the View and it still
> gives me the ERROR I also tried Granting the user access to the View and
it
> didn't work either and lastly The View is updateable...
>
> Any other Ideas?
>
> Richard


Robert Waywell Posted on 2003-05-21 18:15:01.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub> <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums>
Subject: Re: How to Configure User Access to update tables.
Date: Wed, 21 May 2003 14:15:01 -0400
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <OfKGiV8HDHA.220@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1052
Article PK: 3980

Did you want to post the SQL statements you used to create the base tables,
views, users and grant the permissions?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Richard> wrote in message
news:AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums...
> Thanks for your response...
> I do have a group that has GRANT Update access to the View and it still
> gives me the ERROR I also tried Granting the user access to the View and
it
> didn't work either and lastly The View is updateable...
>
> Any other Ideas?
>
> Richard


Richard Posted on 2003-05-22 22:41:42.0Z
From: Richard
Date: Thu, 22 May 2003 18:41:42 -0400
Newsgroups: ianywhere.public.general
Subject: Re: How to Configure User Access to update tables.
Message-ID: <650E0B42568107C3007CAAAB85256D2E.00696BA585256D2D@webforums>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub> <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums> <OfKGiV8HDHA.220@forums-1-dub>
Lines: 41
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1061
Article PK: 3012

Here is the Base Table:

IF Object_ID('Sec_Verus_User') IS NOT NULL THEN
DROP TABLE Sec_Verus_User
END IF;

CREATE TABLE Sec_Verus_User (

Verus_User_Link_Code AUTOLINKCODE PRIMARY KEY,
Date_Added DATEADDED,
Date_Edited DATEEDITED,
User_Added USERADDED,
User_Edited USEREDITED,
Secured_Features_Link_Code INTEGER NOT NULL,
UserName CHAR(254)
NOT NULL,
Security_Mask INTEGER DEFAULT 0

);


HERE IS THE VIEW:


IF Object_ID('vw_Adm_UserFeatures') IS NOT NULL THEN
DROP VIEW vw_Adm_UserFeatures
END IF;


CREATE VIEW vw_Adm_UserFeatures ( )
AS
SELECT vu.Verus_User_Link_Code,vu.Security_Mask,vu.UserName
FROM Sec_Verus_User as vu

GRANT SELECT ON DBA.vw_Adm_UserFeatures TO SecAdmin;
GRANT UPDATE ON DBA.vw_Adm_UserFeatures TO SecAdmin;

Do you need anything else?

Thanks!
Richard


Robert Waywell Posted on 2003-05-23 13:09:35.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub> <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums> <OfKGiV8HDHA.220@forums-1-dub> <650E0B42568107C3007CAAAB85256D2E.00696BA585256D2D@webforums>
Subject: Re: How to Configure User Access to update tables.
Date: Fri, 23 May 2003 09:09:35 -0400
Lines: 116
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#vKSN0SIDHA.221@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1064
Article PK: 3013

Here are the commands I ran using 8.0.2.4218 and the UPDATE succeeded:

grant connect to secadmin identified by sql;

IF Object_ID('Sec_Verus_User') IS NOT NULL THEN
DROP TABLE Sec_Verus_User
END IF;

CREATE TABLE Sec_Verus_User (

Verus_User_Link_Code int PRIMARY KEY,
Date_Added DATE,
Date_Edited DATE,
User_Added char(30),
User_Edited char(30),
Secured_Features_Link_Code INTEGER NOT NULL,
UserName CHAR(254)
NOT NULL,
Security_Mask INTEGER DEFAULT 0

);


//HERE IS THE VIEW:


IF Object_ID('vw_Adm_UserFeatures') IS NOT NULL THEN
DROP VIEW vw_Adm_UserFeatures
END IF;


CREATE VIEW vw_Adm_UserFeatures ( )
AS
SELECT vu.Verus_User_Link_Code,vu.Security_Mask,vu.UserName
FROM Sec_Verus_User as vu

GRANT SELECT ON DBA.vw_Adm_UserFeatures TO SecAdmin;
GRANT UPDATE ON DBA.vw_Adm_UserFeatures TO SecAdmin;


insert into Sec_Verus_User values(1, today(), today(), 'abc', 'xyz',
23,'george',42);
commit;

connect secadmin;
update dba.vw_Adm_UserFeatures set username = 'paul' where
werus_user_link_code = 1;
commit;


--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Richard> wrote in message
news:650E0B42568107C3007CAAAB85256D2E.00696BA585256D2D@webforums...
> Here is the Base Table:
>
> IF Object_ID('Sec_Verus_User') IS NOT NULL THEN
> DROP TABLE Sec_Verus_User
> END IF;
>
> CREATE TABLE Sec_Verus_User (
>
> Verus_User_Link_Code AUTOLINKCODE PRIMARY KEY,
> Date_Added DATEADDED,
> Date_Edited DATEEDITED,
> User_Added USERADDED,
> User_Edited USEREDITED,
> Secured_Features_Link_Code INTEGER NOT NULL,
> UserName CHAR(254)
> NOT NULL,
> Security_Mask INTEGER DEFAULT 0
>
> );
>
>
> HERE IS THE VIEW:
>
>
> IF Object_ID('vw_Adm_UserFeatures') IS NOT NULL THEN
> DROP VIEW vw_Adm_UserFeatures
> END IF;
>
>
> CREATE VIEW vw_Adm_UserFeatures ( )
> AS
> SELECT vu.Verus_User_Link_Code,vu.Security_Mask,vu.UserName
> FROM Sec_Verus_User as vu
>
> GRANT SELECT ON DBA.vw_Adm_UserFeatures TO SecAdmin;
> GRANT UPDATE ON DBA.vw_Adm_UserFeatures TO SecAdmin;
>
> Do you need anything else?
>
> Thanks!
> Richard


Richard Posted on 2003-05-23 16:41:49.0Z
From: Richard
Date: Fri, 23 May 2003 12:41:49 -0400
Newsgroups: ianywhere.public.general
Subject: Re: How to Configure User Access to update tables.
Message-ID: <B08ACA010B07E327005BB85085256D2F.004D514A85256D2F@webforums>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub> <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums> <OfKGiV8HDHA.220@forums-1-dub> <650E0B42568107C3007CAAAB85256D2E.00696BA585256D2D@webforums> <#vKSN0SIDHA.221@forums-1-dub>
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1068
Article PK: 3360

The
GRANT CONNECT TO SecAdmin Identified by SQL;

is what I needed to get it to work!!!

Thanks!

Richard


Robert Waywell Posted on 2003-05-26 14:09:48.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub> <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums> <OfKGiV8HDHA.220@forums-1-dub> <650E0B42568107C3007CAAAB85256D2E.00696BA585256D2D@webforums> <#vKSN0SIDHA.221@forums-1-dub> <B08ACA010B07E327005BB85085256D2F.004D514A85256D2F@webforums>
Subject: Re: How to Configure User Access to update tables.
Date: Mon, 26 May 2003 10:09:48 -0400
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <ORPf4D5IDHA.311@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1074
Article PK: 3020

That's really weird, all that statement does is create the user id, you
shouldn't have been able to grant permissions to the user until after it had
been created. Are you sure you were connecting with the user id SECADMIN in
your earlier test?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Richard> wrote in message
news:B08ACA010B07E327005BB85085256D2F.004D514A85256D2F@webforums...
>
> The
> GRANT CONNECT TO SecAdmin Identified by SQL;
>
> is what I needed to get it to work!!!
>
> Thanks!
>
> Richard


Richard Posted on 2003-05-28 13:58:48.0Z
From: "Richard" <Richardr@ldsinc.com>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub> <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums> <OfKGiV8HDHA.220@forums-1-dub> <650E0B42568107C3007CAAAB85256D2E.00696BA585256D2D@webforums> <#vKSN0SIDHA.221@forums-1-dub> <B08ACA010B07E327005BB85085256D2F.004D514A85256D2F@webforums> <ORPf4D5IDHA.311@forums-1-dub>
Subject: Re: How to Configure User Access to update tables.
Date: Wed, 28 May 2003 08:58:48 -0500
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <OZPrKHSJDHA.221@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: lds253.ldsinc.com 66.6.104.253
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1089
Article PK: 3368

You are right it didn't really work...Something happened that that
allowed...we recreate the db and view ect. and is not working again...I am
logging the user in through the App and again to recap the conditions.

1) User is logged in through VB App
2) User ID is: vradm
3) Group name: SecAdm <<<Not sure if I need or just to use USERID
4) User is member of SecAdmin
5) View: has been granted Select, Update to SecAdm
6) App Opens Disconnected Recordset with View <<Note I am not using update
statement like you outlined in previous post.
7) App reconnects Recordset and executes a UpdateBatch <<<this is where the
error occurs.

Thanks for the Help!!
Richard

"Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
news:ORPf4D5IDHA.311@forums-1-dub...
> That's really weird, all that statement does is create the user id, you
> shouldn't have been able to grant permissions to the user until after it
had
> been created. Are you sure you were connecting with the user id SECADMIN
in
> your earlier test?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> <Richard> wrote in message
> news:B08ACA010B07E327005BB85085256D2F.004D514A85256D2F@webforums...
> >
> > The
> > GRANT CONNECT TO SecAdmin Identified by SQL;
> >
> > is what I needed to get it to work!!!
> >
> > Thanks!
> >
> > Richard
>
>


Robert Waywell Posted on 2003-05-28 14:59:56.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub> <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums> <OfKGiV8HDHA.220@forums-1-dub> <650E0B42568107C3007CAAAB85256D2E.00696BA585256D2D@webforums> <#vKSN0SIDHA.221@forums-1-dub> <B08ACA010B07E327005BB85085256D2F.004D514A85256D2F@webforums> <ORPf4D5IDHA.311@forums-1-dub> <OZPrKHSJDHA.221@forums-1-dub>
Subject: Re: How to Configure User Access to update tables.
Date: Wed, 28 May 2003 10:59:56 -0400
Lines: 95
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <ugedPpSJDHA.220@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1090
Article PK: 3369

Ok, now it would be a good idea to get a Request Level Log to see what
operations are actually being sent to the database. I suspect you may be
getting deletes and updates sent to the database when you execute the
UpdateBatch command. To get the request level log you need to run the engine
with the -zr SQL -zo <filename> switches.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Richard" <Richardr@ldsinc.com> wrote in message
news:OZPrKHSJDHA.221@forums-1-dub...
> You are right it didn't really work...Something happened that that
> allowed...we recreate the db and view ect. and is not working again...I am
> logging the user in through the App and again to recap the conditions.
>
> 1) User is logged in through VB App
> 2) User ID is: vradm
> 3) Group name: SecAdm <<<Not sure if I need or just to use USERID
> 4) User is member of SecAdmin
> 5) View: has been granted Select, Update to SecAdm
> 6) App Opens Disconnected Recordset with View <<Note I am not using update
> statement like you outlined in previous post.
> 7) App reconnects Recordset and executes a UpdateBatch <<<this is where
the
> error occurs.
>
> Thanks for the Help!!
> Richard
>
> "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> news:ORPf4D5IDHA.311@forums-1-dub...
> > That's really weird, all that statement does is create the user id, you
> > shouldn't have been able to grant permissions to the user until after it
> had
> > been created. Are you sure you were connecting with the user id SECADMIN
> in
> > your earlier test?
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > <Richard> wrote in message
> > news:B08ACA010B07E327005BB85085256D2F.004D514A85256D2F@webforums...
> > >
> > > The
> > > GRANT CONNECT TO SecAdmin Identified by SQL;
> > >
> > > is what I needed to get it to work!!!
> > >
> > > Thanks!
> > >
> > > Richard
> >
> >
>
>


Richard Posted on 2003-05-28 20:18:41.0Z
From: "Richard" <Richardr@ldsinc.com>
References: <628B66D9D44C02170049C7D185256D2C.0049C80C85256D2C@webforums> <#NXuRuwHDHA.277@forums-2-dub> <AC1F86E18BE1C3D9007B1F6885256D2C.0075239A85256D2C@webforums> <OfKGiV8HDHA.220@forums-1-dub> <650E0B42568107C3007CAAAB85256D2E.00696BA585256D2D@webforums> <#vKSN0SIDHA.221@forums-1-dub> <B08ACA010B07E327005BB85085256D2F.004D514A85256D2F@webforums> <ORPf4D5IDHA.311@forums-1-dub> <OZPrKHSJDHA.221@forums-1-dub> <ugedPpSJDHA.220@forums-1-dub>
Subject: Re: How to Configure User Access to update tables.
Date: Wed, 28 May 2003 15:18:41 -0500
Lines: 3129
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <OZ5LcbVJDHA.221@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: lds253.ldsinc.com 66.6.104.253
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1105
Article PK: 3382

Robert

Here is the Log file you requested

Thanks for the help!!
Richard

"Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
news:ugedPpSJDHA.220@forums-1-dub...
> Ok, now it would be a good idea to get a Request Level Log to see what
> operations are actually being sent to the database. I suspect you may be
> getting deletes and updates sent to the database when you execute the
> UpdateBatch command. To get the request level log you need to run the
engine
> with the -zr SQL -zo <filename> switches.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Richard" <Richardr@ldsinc.com> wrote in message
> news:OZPrKHSJDHA.221@forums-1-dub...
> > You are right it didn't really work...Something happened that that
> > allowed...we recreate the db and view ect. and is not working again...I
am
> > logging the user in through the App and again to recap the conditions.
> >
> > 1) User is logged in through VB App
> > 2) User ID is: vradm
> > 3) Group name: SecAdm <<<Not sure if I need or just to use USERID
> > 4) User is member of SecAdmin
> > 5) View: has been granted Select, Update to SecAdm
> > 6) App Opens Disconnected Recordset with View <<Note I am not using
update
> > statement like you outlined in previous post.
> > 7) App reconnects Recordset and executes a UpdateBatch <<<this is where
> the
> > error occurs.
> >
> > Thanks for the Help!!
> > Richard
> >
> > "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> > news:ORPf4D5IDHA.311@forums-1-dub...
> > > That's really weird, all that statement does is create the user id,
you
> > > shouldn't have been able to grant permissions to the user until after
it
> > had
> > > been created. Are you sure you were connecting with the user id
SECADMIN
> > in
> > > your earlier test?
> > >
> > > --
> > > -----------------------------------------------
> > > Robert Waywell
> > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > Sybase Certified Professional
> > >
> > > Sybase's iAnywhere Solutions
> > >
> > > Please respond ONLY to newsgroup
> > >
> > > EBF's and Patches: http://downloads.sybase.com
> > > choose SQL Anywhere Studio >> change 'time frame' to all
> > >
> > > To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
> > >
> > > SQL Anywhere Studio Supported Platforms and Support Status
> > > http://my.sybase.com/detail?id=1002288
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available through the
> > iAnywhere
> > > Developer Community at www.ianywhere.com/developer
> > >
> > > <Richard> wrote in message
> > > news:B08ACA010B07E327005BB85085256D2F.004D514A85256D2F@webforums...
> > > >
> > > > The
> > > > GRANT CONNECT TO SecAdmin Identified by SQL;
> > > >
> > > > is what I needed to get it to work!!!
> > > >
> > > > Thanks!
> > > >
> > > > Richard
> > >
> > >
> >
> >
>
>