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. :-)
Ravi
Hello Ravi,
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.
regards,Neha
Hi Neha,
Add that schema user1 to SYS_REPO user with select privilege.Then do data preview,it will show the data.Let me know if you face any other issue.
Rgds,Murali
Hello Murali,
I also tried the same. But when i am tries to add and save the same. It throwing me following error:
Could not modify user '_SYS_REPO'. Could not grant privilege 'EXECUTE' on 'USER1'. Missing privileges to perform the required actions.
Regards,neha
Yes,The reason is,you are trying to add via Non System User.Open the User1 via SYSTEM user,and then try to add USER1 schema to SYS_REPO user with Select privilege
If it still throws authorization error,kindly get back.
Rgds,Murali
hello Murali,
I tried to add the user1 schema in _sys_repo with select privilege. But it throwing me error again.
Could not modify user '_SYS_REPO'. Could not grant privilege 'SELECT' on 'USER1'. Missing privileges to perform the required actions.
Regards,Neha
Hi Neha,
Just to make the point clear,do you want to do the following
Lets say,
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
Rgds,Murali
Hello Murali,
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.
Regards,
Neha
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
Rgds,Murali
Hello Murali,
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.
Please help..
I think some privilege are missing for the admin also.
Regards,Neha
Hi Neha,
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.
Note:
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.
Rgds,Murali
Hello Murali,
Which screenshot you need, i will provide you.. if possiible, can you please share your email id?
Regards,Neha
Hello Murali,
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.
Please help
Neha
Hi Neha,
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
(256)
) AS BUILTIN
Rgds,
Murali
Hello Murali,
Thanks for the reply will check and update you..
Regards,neha
Does this have to be so complex. Why can't we just use the standard templates ( SAP_TEMPLATE_ MODELLING) / roles (modelling) and then append to the user as needed by project and new object creation?
Please comment.
Rama
Hi Neha,
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.
Ravi
