Is it possible to granting privileges on a schema level?

Published: 27 Apr 2005

Is there a simple way to grant privileges on a schema level?
No, privileges are granted at the object level (table, view, sequence, etc.) or are system privileges (create table, create procedure, etc.). The "any" privileges, such as "select any table" or "create any table" are system privileges, but they are more than schema-wide, they are database-wide.

Dig Deeper on Oracle database security

SearchDataManagement

Instaclustr CTO on open source database as a service

Ben Bromhead, co-founder and CTO of Instaclustr, provides insight into the state of the open source database-as-a-service market ...

Percona users detail open source database challenges

Speakers from Shopify and LinkedIn outline open source database cloud and security challenges and best practices at the Percona ...

Grafana 7.0 from Grafana Labs expands data visualization

Distributed tracing data joins log metrics in Grafana 7.0 release, providing users with more ways to connect, observe and ...

SearchBusinessAnalytics

HR use case shows value of Oracle Analytics Cloud

A use case presented during Oracle Analytics' virtual user conference shows how the vendor's platform can bring value to an ...

Sisense helps Soft Stuff pivot business during pandemic

Soft Stuff, a wholesale distributor of gourmet foods, was able to change its business strategy amid the COVID-19 crisis, thanks ...

4 features of great data visualization and storytelling

Data visualization and storytelling go hand in hand when it comes to explaining data. Here are four ways to make sure you build ...

SearchSAP

SAP S/4HANA Cloud 2005 focuses on supply chain

The latest version of S/4HANA Cloud has functions for supply chain, finance and SuccessFactors integration that will likely ...

SAP HANA database turns 10

In this Q&A, SAP's Gerrit Kazmaier discusses how the SAP HANA database has become the platform to enable the intelligent ...

SAP App Center a bridge between ISVs and customers

SAP customers and ISV application developers describe how they use the SAP App Center to find and deploy useful, integrated and ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

The Ben Franklin Effect and software developer career advice

Are you a new programmer in need of a quick and simple way to blend in with your team? Here's some career advice from none other ...

Oracle's Project Leyden uses static images to ease Java pain

Oracle's new Project Leyden introduces static images to help ease long-standing Java language shortcomings such as slow startup ...

Oracle's GraalVM finds its place in Java app ecosystem

Oracle's GraalVM, a universal virtual machine that runs apps written in Java and other languages, has carved out a spot in the ...

SearchDataCenter

Microsoft supercomputer looks to create AI models in Azure

Microsoft has expanded its AI initiative up to the supercomputer market, unveiling a system focused on helping users build large ...

Data center liquid cooling market heats up

As organizations increase server rack density, more C-level execs investigate liquid cooling technology. Industry experts see ...

Considerations for SIEM logging software and storage

SIEM systems aggregate a lot of data across all types of infrastructure. For regular audits, admins should address notification ...

SearchContentManagement

Adobe Experience Manager buoys U.S. census during pandemic

The first U.S. Census digital experience was launched in time for the pandemic, and now Adobe looks to parlay the success into ...

Microsoft buys Softomotive to boost Power Platform RPA

Microsoft's acquisition of Softomotive gives Power Automate users a low-code RPA system to build bots for Windows-based tasks.

Get to know key features of content services platforms

A content services platform is more than a database -- it is an intelligent information engine. Organizations should be familiar ...

SearchHRSoftware

Zuckerberg lists benefits, drawbacks of remote work

After the pandemic, Facebook co-founder and CEO Mark Zuckerberg believes his firm will have more employees who work remotely, ...

HR technologies solidify HR employee experience near and far

Culture, physical and virtual workspaces, and policies play key roles in fostering worker loyalty and engagement -- with the help...

AI in HR recruitment targets high-demand technology talent

As demand for technology talent persists, even during pandemic times, AI, chatbots and machine learning play an increasingly ...

Dig Deeper on Oracle database security

How to create Oracle Multitenant database user accounts

REST vs. SOAP: Choosing the best web service

Object privileges in Oracle database security

star schema

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.