Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View Security Problem. I've never seen this.

Status
Not open for further replies.

cehagema

Programmer
Oct 2, 2003
9
US
Hello- I've created a view as 'sa' but other users cannot access it. Symptoms are 1) Crystal Locks Up. 2) Querying the view thru Query Analyzer runs forever. 3) Clicking on Table Columns in Query Analyzer takes a while and then shows nothing and the + symbol disappears as if the table had no columns??? I've checked and users have select access to underlying tables and the view. It runs fine with any DBA login. And the other wierd thing is that pasting the create view script into anther window and removing "create view viewname as" part and then running it works fine. I've done this many times before and never had this problem. What do you think?
Thanks
Chris
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top