rahul kumar
asked on
Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Oracle][ODBC][Ora]ORA-00942: table or view does not exist
dim rs
dim user1
dim pass1
dim role
dim strsql
set rs=server.CreateObject("AD ODB.Record set")
if session("user")="" then
Response.Redirect "loginpage.asp"
end if
'Response.Write session("user")
strsql="select granted_role from user_role_privs"
rs.Open strsql,Session("conn")
role=rs.Fields(0)
rs.Close()
set rs=nothing
'-----------for war alert...-----------
if session("user")="ADMINISTR ATOR" or role="CSG_ROLE" then
set rs=server.CreateObject("AD ODB.Record set")
strsql="select WARRANTY_DT,asset_no from tabasset where WARRANTY_DT<=(sysdate+90) and WARRANTY_DT>=(sysdate-30)"
rs.Open strsql,session("conn"),3 ( Shows Error in this line)
'Response.Write rs.Fields(0)
if not rs.EOF then%>
dim user1
dim pass1
dim role
dim strsql
set rs=server.CreateObject("AD
if session("user")="" then
Response.Redirect "loginpage.asp"
end if
'Response.Write session("user")
strsql="select granted_role from user_role_privs"
rs.Open strsql,Session("conn")
role=rs.Fields(0)
rs.Close()
set rs=nothing
'-----------for war alert...-----------
if session("user")="ADMINISTR
set rs=server.CreateObject("AD
strsql="select WARRANTY_DT,asset_no from tabasset where WARRANTY_DT<=(sysdate+90) and WARRANTY_DT>=(sysdate-30)"
rs.Open strsql,session("conn"),3 ( Shows Error in this line)
'Response.Write rs.Fields(0)
if not rs.EOF then%>
It seems that your user has no privilegies on table tabasset.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.