Two questions:

I made new user (from dba), who will have select access to some queries 
owned by another user.  I logged in as the data owner user and GRANTed 
access to the new user to SELECT on the views.  I then logged in as the 
new user (in SQL Studio) and ran some queries to make sure it worked (it 
did).  I saved these queries to the server, and then went to webSQL....

problem a:
Error like "Could not connect to data-source: User already logged in" - 
only one login??  I logged out of SQL Studio, then it worked in web-sql.. 
sort-of. 

problem b:
When I log into SQL Studio as the new user, there is no stored query view 
on the left side, as there normally is, despite the fact that this new 
user does have queries saved.  Any ideas here?

somehow I am sure I just need to modify some permissions somewhere... but 
which ones?

Thank you,
      Noah Silva
      IS&T - Programmer Analyst
      (215) 419 - 7916
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to