What is the purpose of giving grant dba,connect,resource to some user....
What is this actually do?
if i give this, is it necessary to grant select update privileges to that user or no need.....
and one more....how to revoke dba,connect and resource privileges from that user...
Kindly help...thanks
4  1567  connect means the user can connect to the database ,u can also grant create session for the same purpose.
resource means the user has previlege on the default tablespace .So the user can create his own objects like tables ,views etc...
if you grant dba the user gets previleges on some of the data dictionaries , on which normal user does not have any previleges.
grant select ,insert ,update is different from the previous grant . these are object previleges ,means these are granted on specified objects . And only the owner of the object or any other user who have required previleges on those objects can grant these to others.
connect means the user can connect to the database ,u can also grant create session for the same purpose.
resource means the user has previlege on the default tablespace .So the user can create his own objects like tables ,views etc...
if you grant dba the user gets previleges on some of the data dictionaries , on which normal user does not have any previleges.
grant select ,insert ,update is different from the previous grant . these are object previleges ,means these are granted on specified objects . And only the owner of the object or any other user who have required previleges on those objects can grant these to others.
thanks..but how to revoke those system privileges after it has been granted
Hi
revoke <1st priv>, <2nd priv> on <objectname> from <username>;
Hope this helps
to revoke the system previleges do not use object name as it is not on a object.
for ex
========= - REVOKE CONNECT FROM SCOTT;
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Perttu Pulkkinen |
last post by:
Content management system I'm working consists pages, categories, users (and
images). It is in the first place dircted to companies where 1-10 persons
are taking care of site content. I am thinking...
|
by: Amardeep Verma |
last post by:
Hi,
I have a quick question. Which role/privileges are required before
a user can give the statement "GRANT ALL PRIVILEGES"?
Thanking you in Advance
Have a nice day
|
by: Zeng |
last post by:
Hi,
I'm running ClrProfiler for the first time to profile my web app, and it
keeps getting stuck at this msg box: "Waiting for Asp.net to start common
language runtime - this is the time to load...
|
by: 21novembre |
last post by:
Hi all,
I got a quite strange problem when I tried to setup a database backup
shell. I put it this way:
"bin/mysqldump --opt --user=xxx --password=xxx DB > DB.bak"
However, error 1045 came to...
|
by: tabai |
last post by:
Hi.
I'm trying the database privileges, I create diferent users in my
database server. Use A and user B in two diferents groups (GA and GB),
I create a database (DBA) with user A, and grant...
|
by: Rider |
last post by:
Hi, simple(?) question about asp.net configuration..
I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm
first start application the follow message shown.
=========
Server...
|
by: fReDiNi |
last post by:
Hi, I have being trying fo find the best solution for this problem for
2 days now and I am not able to find a solution.I need help.
I explain the problem:
A customer needs a system so that...
|
by: CrimeMaster |
last post by:
I have write some simple code,this code does not shows network mapped
drives when we run it under system account, otherwise under user
account it shows them correctly.
Any body tell me why did...
|
by: giddy |
last post by:
hi,
(I want someone to check if my idea is utterly stupid or ok??)
I have a mid complex app for a hotel that needs a fine grained user
security system. In other words an admin should be able...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
|
by: Matthew3360 |
last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
|
by: AndyPSV |
last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
|
by: Arjunsri |
last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
|
by: WisdomUfot |
last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
|
by: Matthew3360 |
last post by:
Hi,
I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
|
by: Carina712 |
last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
|
by: BLUEPANDA |
last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
|
by: Rahul1995seven |
last post by:
Introduction:
In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
| |
