HI, @puzinoj , I want to do the same process, but I haven't found a method yet, please, how are you doing it?
Thanks @roklde
I tried now, the same error appears
@Matheus.Avancera sorry, my mistake - I meant METRIX_USER_TYPE. Best regards Roman Thank you, it seems OK to me
Hi @roklde , I don't have the metrix_license_type column in the person_id table /****** Script for SelectTopNRows command from SSMS ******/SELECT TOP (1000) [T_PRIMARY_KEY] ,[T_CONTROL_PRIMARY_KEY] ,[T_TRANSACTION_TYPE] ,[T_RECORD_STATUS] ,[T_INTERFACE_ERRORS] ,[T_MODIFIED_BY] ,[T_MODIFIED_DTTM] ,[T_CREATED_BY] ,[T_CREATED_DTTM] ,[ACCESS_GROUP] ,[ALT_APPROVER] ,[ALT_EMAIL_ADDRESS] ,[ALT_PAGER] ,[ALT_PAGER_ID_NUM] ,[ALT_PAGER_TYPE] ,[APPROVAL_LIMIT] ,[APPROVAL_STRENGTH] ,[APPROVER] ,[CALENDAR_ID] ,[CORPORATE_CURRENCY] ,[CREATED_BY] ,[CREATED_DTTM] ,[CURRENCY] ,[DAILY_CAPACITY] ,[DATE_OF_BIRTH] ,[DFLT_CONTR_PST_GRP] ,[DFLT_REQ_PST_GRP] ,[DISPATCHABLE] ,[EMAIL_ADDRESS] ,[EMPLOYEE] ,[EXTENSION] ,[EXTERNAL_REFERENCE] ,[FAX] ,[FIRST_NAME] ,[GENDER] ,[GEOCODE_ID] ,[GEOCODE_LAT] ,[GEOCODE_LONG] ,[GL_ACCT_C
I had a license error when accessing the client, I applied a license that was sent to me and I was left without access to the environment.I found the person_id table but how do I check if there is a license assigned to the user?
Hi, What was the solution to the problem? I, have the same problem.
Thank you Dharshika, I opened this post cause another user asked me about this, i will ask him to interage with this post.
thank you
Hi, eu runned out all steps, but still have problems, any more ideas?
Hi,i executed de permissions for IFSAPP and IFSSYS, run the select and the permissions are OK fot both users, but i have de the same error.
Hi,the topic is blocked for me, when i run this select its return that “sys.dbms_network_acl_admin does not exist”
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.