-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- SQLScript REVOKE command issue
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SQLScript REVOKE command issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2017 Jan 12 8:45 AM
- SAP Managed Tags
- SQL
Hi,
I executed this Revoke command for one of my table.
REVOKE SELECT ON "CLF01"."CAR" from _sys_repo;
i was expecting that after this i will not be able to execute select query on this table but i can see records with no issue.
could anybody please help what im doing wrong with this Revoke.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2017 Jan 27 2:14 PM
- SAP Managed Tags
- SQL
With that statement you revoke the select privileges for the specific table from user _SYS_REPO. That means that this user cannot read data anymore. For instance if you have a defined a calculation view getting data from that table, you get an authorization error, cause the calc. view belongs to and is executed by _SYS_REPO which has not rights anymore.
If you do a select with another user (which I assume you did e.g. in the console) and the user has privileges the selection works. So the question is: What user you used and what privileges he has?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2017 Jan 27 2:14 PM
- SAP Managed Tags
- SQL
With that statement you revoke the select privileges for the specific table from user _SYS_REPO. That means that this user cannot read data anymore. For instance if you have a defined a calculation view getting data from that table, you get an authorization error, cause the calc. view belongs to and is executed by _SYS_REPO which has not rights anymore.
If you do a select with another user (which I assume you did e.g. in the console) and the user has privileges the selection works. So the question is: What user you used and what privileges he has?
Bluesky