I have a user say User1. Automatically the user1 schema is created under catalog.
User1 created the table under user1 schema.
If ,I am the administrator and try to preview the data then it is showing insufficient privilege error
If , i trying to add the user1 schema in the Analytical privilege then it is not allowing me to add the same.
Is, it possible to do the same. If, yes then how?
Thanks in advance.
As an administrator, do you mean as SYS user ? If so, then you should have access to the object created in any schema.
If your admin user is mapped to another schema then you need to add the privs.
And also one point, (as learnt by experience), some times it doesn't let you save the privs. The option is to close and log in again and then it works. :-)
I created a user that is user1 with limited authorization means that user is not a admin user.
when i created the user the automatically one schema is created under catalog.
If user1 is creating any table so, as a admin I am not able to see the data as it throwing error insufficient privilege.
So, what i need to do for the same.
I restarted the system also and then try it what it didn't work.
Just to make the point clear,do you want to do the following
1.You added the New DB system with SYSTEM user who is a Admin user
2.You have created a New User say "NONSYSUSER"
3.Now you will be able to see new schema "NONSYSUSER" under Catalog
4.You created some tables under this schema
Now try to do data preview of it
To see data here,add the schema"NONSYSUSER" to _SYS_REPO user with Select privilege
5.Now add the New DB system as NONSYSUSER user
6.Do a data preview on the same table
You will be able to see the data
Actually you are not getting me..
1. I logged with Admin user. I created a user say User1. Automatically one schema is created under catalog.
2. I logged with User1. I created a table say table1 and enter the enteries.
3. I again logged with admin. Now , If i am trying to preview the table1, I am not able to see the data.
4. If i am trying to add the shema under _sys_repo its throwing me the error
Could not modify user '_SYS_REPO'. Could not grant privilege 'SELECT' on 'USER1'. Missing privileges to perform the required actions.
Ok, Got your point
I exactly tried your scenario.
Steps 1 and 2 are fine
In Step3,when you log in with admin,you wont be able to see the User1 schema, unless until you add it for System user->SQL privileges tab with SELECT checked
Now do a data preview on the table,you will see the data
That only I am saying, if i am try to add the same in the _sys_repo or SQL Privilege or admin user, I am getting the following error.
Could not modify user 'SYSTEM'. Could not grant privilege 'SELECT' on 'USER1'. Missing privileges to perform the required actions.
I think some privilege are missing for the admin also.
Yes,I guess we are missing somewhere.To make it more clear can u provide the screenshots (if possible) with the steps to trouble shoot the issue.
We also came across lot of privilege issues and rectified in our systems.This could be a minor issue which can be fixed with proper privilege assignments.
When you try to add User1 schema under SQL Privileges for SYSTEM user via Non System user(User1),you should nt get any Auth error as we are granting the SYSTEM user to view the Non System User's schema created by him.
I need the step by step screen shot
You can contact me @ email@example.com
The GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT with EXECUTE is not there in the SQL priviledge and if I searching for the same it is not showing me in the search.
Is there any way to create the same?
I sent you the mail also. i think you didn't check over there.
This procedure will be under Catalog->_SYS_REPO->Procedures.
If you don't find one,you can create
CREATE PROCEDURE _SYS_REPO.GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT
(IN privilege VARCHAR
(256), IN schemaName VARCHAR
(256), IN userName VARCHAR
) AS BUILTIN
What was the final solution to this issue ?. I am having same issue, I am not able to grant access to procedure using SYSTEM or owner of the stored procedure to _SYS_REPO Id.
I am getting below error:
Could not modify user '_SYS_REPO'. Could not grant privilege 'EXECUTE' on 'PROC_DETERMINE_AUTH_PLANT (SLTECC)'. You are not authorized to perform the required actions.
In my system I can see _SYS_REPO with SELECT privs on the new user created. As Murali said, this should be done with the system user.
Again as I said earlier, many a times though you select the system user to perform the operation, it still doesn't use the system user id. So you close the application and log in again to System user and perform the activity.
Hope it will work for you.
--> Login as USER1
--> expand the USERS tab
--> open the ADMIN user
--> goto OBJECT privileges
--> select the schema name, here USER1
--> select the options what ever you want
based on your requirement, here if you want see select SELECT option.
--> save and excute it ...
I think it will work 100%, if not please let me know.