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!

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

SqlAnywhere 5.0

Status
Not open for further replies.
jbeetz1

jbeetz1

Programmer
Nov 28, 2000
60
US
I have a PB application that uses a SqlAywhere 5.0 database. All the datawindows and sql queries are built without preceeding the tables with the owner "dba.customers" versus "customers". I now want to create another login that will have full access to insert, update and delete rows from tables. However I cannot figure out how to do this without modifying every datawindow and sql query to add the owners name which is a huge job. Is there any SqlAnywhere command that I can use to create an alias for each table that will allow a new user ID to access the tables without having to change all the datawindows and sql queries.

Thanks for your help.
Jerry
 
Status
Not open for further replies.

Similar threads

kevboac
  • Locked
  • Question
Powerbuilder 5.0
Replies
3
Views
58
kevboac
kevboac
mp51085
  • Locked
  • Question
PowerBuilder 5.0.0.4 link error
Replies
3
Views
35
bigbillmac
bigbillmac
Guest_imported
  • Locked
  • Question
Migrating from 5.0.4 to 6.5 or 7.0 on windows 2000
Replies
0
Views
27
Guest_imported
Guest_imported

Part and Inventory Search

Sponsor

Back
Top