Symptom
1> select * from tab1
2> go
Msg 208, Level 16, State 1:
Server 'ASE', Line 1:
tab1 not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
1> select owner = user_name(uid), name, type from sysobjects where name = "tab1""
2> go
owner name type
------------ ------------------- ----
user1 tab1 U
(1 row affected)
1> sp_displaylogin user1
2> go
Suid: 15
Loginame: user1
Fullname:
Default Database: ASE
Default Language:
Auto Login Script:
Configured Authorization:
sa_role (default ON)
Locked: NO
Date of Last Password Change: Nov 8 2024 7:23AM
Password expiration interval: 0
Password expired: NO
Minimum password length: 6
Maximum failed logins: 0
Current failed login attempts: 0
Authenticate with: AUTH_DEFAULT
Login Password Encryption: SHA-256
Last login date: Dec 1 2024 5:32AM
Exempt inactive lock: 0
(return status = 0)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview