What happens if the DBA does not allow users to execute system stored procedures?


What happens if the DBA does not allow users to execute system stored...
Author
Message
Marcia G Akins
Marcia G Akins
Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)
Group: StrataFrame Users
Posts: 322, Visits: 529
Hi All.

Just curious about this because at the when I started this app, I spent a lot of time in SQL Profiler trying to figure out why things were not working as I expected them to Wink That was when I noticed that Strataframe was sending a lot of exec SP_EXECUTESQL commands to the server. Now, with my current client and since this is a winforms app, allowing Strataframe to do this does not concern me. However, my husband performed as DBA for Charles Schwab for 18 months and there is absolutely no way that they would allow a user access to system stored procesures (especially with the threat of SQL injection) - the database was totally locked down.

So how does Strataframe get around this situation?

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search