I have 100 hundred fixed licenses for my system.
- If I make a query on the User schema for people with fixed license, I get
99 entries.
- If I try to assign a fixed license to a new user, the system returns me a
message saying that all the 100 fixed licenses have been assigned.
- When I look to the Oracle table for the user cache, I realize that 2 users
with the same logon name are defined but, just one of them is visible
through the User schema.

1) What should I do to delete the invisible record ? I mean, can I delete it
directly from the user cache table or what should I do to free the fixed
license?
2) Are there any known problems in deleting the entry directly from Oracle?

Any suggestion is welcome.

Thank you in advance

Fabrizio Mammini

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

When we pass ARS from production server (86 licenses) to development server (3 licenses), we have to do changes in Oracle (ARS users table) to only have 3 licenses. You can do something similar at database level.
I hope this help you,
Regards.
Domingo del Moral
Ericsson Business Consulting Spain


-----Original Message-----
From: Fabrizio Mammini [mailto:fabrizio.mammini@KATAMAIL.COM]
Sent: Friday, November 26, 1999 3:34 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: "Invisible" fixed license


Hi all,
I have 100 hundred fixed licenses for my system.
- If I make a query on the User schema for people with fixed license, I get
99 entries.
- If I try to assign a fixed license to a new user, the system returns me a
message saying that all the 100 fixed licenses have been assigned.
- When I look to the Oracle table for the user cache, I realize that 2 users
with the same logon name are defined but, just one of them is visible
through the User schema.

1) What should I do to delete the invisible record ? I mean, can I delete it
directly from the user cache table or what should I do to free the fixed
license?
2) Are there any known problems in deleting the entry directly from Oracle?

Any suggestion is welcome.

Thank you in advance

Fabrizio Mammini

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

could you please detail what do you actually do in Oracle ?

Thank you very much

Fabrizio Mammini


Fri, 26 November 1999, "Domingo Del-Moral-Tornero (ESS)" wrote:

>
> Hello,
> When we pass ARS from production server (86 licenses) to development server (3 licenses), we have to do changes in Oracle (ARS users table) to only have 3 licenses. You can do something similar at database level.
> I hope this help you,
> Regards.
> Domingo del Moral
> Ericsson Business Consulting Spain
>
>
> -----Original Message-----
> From: Fabrizio Mammini [mailto:fabrizio.mammini@KATAMAIL.COM]
> Sent: Friday, November 26, 1999 3:34 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: "Invisible" fixed license
>
>
> Hi all,
> I have 100 hundred fixed licenses for my system.
> - If I make a query on the User schema for people with fixed license, I get
> 99 entries.
> - If I try to assign a fixed license to a new user, the system returns me a
> message saying that all the 100 fixed licenses have been assigned.
> - When I look to the Oracle table for the user cache, I realize that 2 users
> with the same logon name are defined but, just one of them is visible
> through the User schema.
>
> 1) What should I do to delete the invisible record ? I mean, can I delete it
> directly from the user cache table or what should I do to free the fixed
> license?
> 2) Are there any known problems in deleting the entry directly from Oracle?
>
> Any suggestion is welcome.
>
> Thank you in advance
>
> Fabrizio Mammini
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist

___________________________________________________
Se vuoi un indirizzo di posta elettronica gratuito,
iscriviti a http://www.katamail.com

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

With SQL-Plus:
1.- To see the ARS user view:
desc aradmin.user_x
2.- To see the ARS users license type (You can have other fields names):
select login_name, full_name, license_type
from aradmin.user_x;
3.- To delete the users cache:
TRUNCATE TABLE ARADMIN.USER_CACHE;

You can use "DELETE" and "UPDATE" with "aradmin.user_x" to delete and change ARS users. I recommend you to have a backup or Oracle export done before any change in users table.

Regards,
Domingo del Moral
Ericsson Business Consulting Spain

-----Original Message-----
From: Fabrizio Mammini [mailto:fabrizio.mammini@KATAMAIL.COM]
Sent: Friday, November 26, 1999 4:28 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: "Invisible" fixed license


Hello,
could you please detail what do you actually do in Oracle ?

Thank you very much

Fabrizio Mammini


Fri, 26 November 1999, "Domingo Del-Moral-Tornero (ESS)" wrote:

>
> Hello,
> When we pass ARS from production server (86 licenses) to development server (3 licenses), we have to do changes in Oracle (ARS users table) to only have 3 licenses. You can do something similar at database level.
> I hope this help you,
> Regards.
> Domingo del Moral
> Ericsson Business Consulting Spain
>
>
> -----Original Message-----
> From: Fabrizio Mammini [mailto:fabrizio.mammini@KATAMAIL.COM]
> Sent: Friday, November 26, 1999 3:34 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: "Invisible" fixed license
>
>
> Hi all,
> I have 100 hundred fixed licenses for my system.
> - If I make a query on the User schema for people with fixed license, I get
> 99 entries.
> - If I try to assign a fixed license to a new user, the system returns me a
> message saying that all the 100 fixed licenses have been assigned.
> - When I look to the Oracle table for the user cache, I realize that 2 users
> with the same logon name are defined but, just one of them is visible
> through the User schema.
>
> 1) What should I do to delete the invisible record ? I mean, can I delete it
> directly from the user cache table or what should I do to free the fixed
> license?
> 2) Are there any known problems in deleting the entry directly from Oracle?
>
> Any suggestion is welcome.
>
> Thank you in advance
>
> Fabrizio Mammini
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist

___________________________________________________
Se vuoi un indirizzo di posta elettronica gratuito,
iscriviti a http://www.katamail.com

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

freed my unassignable fixed write license, which was being held by a user
that had been deleted.

Erika Martin Hubbard
Wang Government Services
Desktop Support
757-492-8433
martinec@nswcphdn.navy.mil



-----Original Message-----
From: Fabrizio Mammini [mailto:fabrizio.mammini@KATAMAIL.COM]
Sent: Friday, November 26, 1999 9:34 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: "Invisible" fixed license


Hi all,
I have 100 hundred fixed licenses for my system.
- If I make a query on the User schema for people with fixed license, I get
99 entries.
- If I try to assign a fixed license to a new user, the system returns me a
message saying that all the 100 fixed licenses have been assigned.
- When I look to the Oracle table for the user cache, I realize that 2 users
with the same logon name are defined but, just one of them is visible
through the User schema.

1) What should I do to delete the invisible record ? I mean, can I delete it
directly from the user cache table or what should I do to free the fixed
license?
2) Are there any known problems in deleting the entry directly from Oracle?

Any suggestion is welcome.

Thank you in advance

Fabrizio Mammini

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist