Re: SqlCommandBuilder

You need to look at the SqlConnection object, which is where the users
connection security is setup via the connection string.

adam

> -----Original Message-----
> From: Vince P [mailto:pacelvi@xxxxxxxxxxxxx]
> Sent: 25 February 2004 15:15
> To: DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx
> Subject: [DOTNET-WINFORMS] SqlCommandBuilder
>
> One of my WinForms is throw up errors about Dynamic SQL not
> being authorized on users who aren't DB Admins.
>
> This particular WinForm uses a class in my data tier that
> uses a SqlCommandBuilder to retreive SqlParameters of a
> SqlDataAdapter (of a Stored
> Procedure)  (note: the form and data tier are running user's
> box, the DB itself is remote)
>
> I'm going to work under the assumption the SqlCommandBuilder
> is using the User's Windows identity to run some Sql against
> the DB tables, and since those users don't have table access,
> the error is being thrown.
>
>
>
> ___________
> Vince P  http://66.93.114.145/vince/
>
> MSN Messenger: this address
> AIM: pacelvi
>
> "Nobody said it'd be easy. Nobody said that it would be this
> hard." - Coldplay
>