How can i know Database type or Connection type?

yukon

Hi Expert,


How can i know database type or connection type? It means current nav connection is SQL or native database. If database is native database, i want to know that connection is local or server.
Another one, can i know current user login type? It means current user is login with window authorization or database . Is it possible to do?



Best Regards,
Yukon

Yaroslav_Gaponov

Hi

Just use CONTEXTURL command and Session table with filter on My Session field

Shedman

SQL or Native you can check by using the RECORDLEVELLOCKING command. If RECORDLEVELLOCKING is true, then you are using SQL.

To check if you're logged on as database or windows user, you can use the corresponding tables. If you don't find USERID in the user table (2000000002) you're probably logged on as a windows user. You could do some extra checks for that in the Windows Login table (2000000054).

yukon

Hi,

Thank 4 your reply. Now i got it. We can check at session table.

Best Regards,
Yukon