No. The database has no knowledge of Named Users --- unless every user
authorised to connect to the database (either through a Client-Server app
or an N-tier architecture) has *his/her own, personal,* database account.
On Sat, 4 May 2019, 03:24 Sundar Mahadevan, <sundarmahadevan82@xxxxxxxxx>
wrote:
Thanks Franck for your response. I agree with you. I had the wrong wording
there. I intended to say NUP users and not database users.
On Fri, May 3, 2019 at 12:18 PM Franck Pachot <franck@xxxxxxxxxx> wrote:
Hi Sundar,
The NUP+ license has nothing to do with the database users. With NUP you
count the end-users. Some examples:
- you have an HR application that is used by the HR team of your company
where there are 10 people -> that's 10 NUP. Whether they connect with their
own user (client/server) or a common account (connection pool) has nothing
to do with that.
- you have two salespeople who use the application from their PC,
laptop, mobile,... through an application server with 150 connections to
150 database users -> that's still 2 NUP
-> you are a university with 20000 students, teachers, and alumni and
the database application is accessed through public internet but with a
login portal that gives access only to those 20000 people -> that's 20000
NUP
-> this application has some pages that show some data from the database
on a public page without login -> that cannot be licensed as NUP as you
cannot count the users
-> you are a small software vendor with 2 developers but the marketing
publishes everywhere that you have 100 developers just to show off...
that's 2 NUP but there are good chances that you get an audit because LMS
think you need 100.
Hope this help. I recommend that you read your contract and the official
documents from LMS.
Regards,
Franck.
On Fri, May 3, 2019 at 8:19 PM Sundar Mahadevan <
sundarmahadevan82@xxxxxxxxx> wrote:
Hi All,
Greetings of the day. I am working on gathering information on our
current license usage. We have NUPS based license and I found v$license
table containing current concurrent users, concurrent users high watermark
along with cpu count (Database versions 9i through 11g on Solaris and 12c
on Linux). Is it safe to assume that the v$license info carries info since
the last database restart considering it is a v$ view? The reason behind
this question is that my company moved from processor based license to NUPS
8 years or so back and the user base was high during the processor based
license and after company reorg, switched to NUPS due to smaller user base.
Are there any other tables that contain the user info? Thanks for your time
and assistance.
