How tough can I be for the user PUBLIC?

Gary

Hello guys!

Bear with me,I am newbie.

I am trying to limit the privileges of the user PUBLIC has as toughly
as possible which means I want to go as far as I can then leave those
MUST-HAVE privileges for user PUBLIC. The question is how far I can
go?

My expectation is once I have done this and I am asked to let my Data
Warehouse users to access the database with only select privileges on
some tables, what I need to do will be creating a role "USER_READ"
with
1. CREATE SESSION and ALTER SESSION system privileges
2. Select privilege on certain user tables as object privileges
then I put all those users in this role.

So, what should I have least for privileges of user PUBLIC then, if I
ask the question in another way?

Cheers!

Gary

Jul 19 '05 #1

Subscribe Post Reply

6104

sybrandb

ro************@yahoo.com.au (Gary) wrote in message news:<17**************************@posting.google. com>...

Hello guys!

Bear with me,I am newbie.

I am trying to limit the privileges of the user PUBLIC has as toughly
as possible which means I want to go as far as I can then leave those
MUST-HAVE privileges for user PUBLIC. The question is how far I can
go?

My expectation is once I have done this and I am asked to let my Data
Warehouse users to access the database with only select privileges on
some tables, what I need to do will be creating a role "USER_READ"
with
1. CREATE SESSION and ALTER SESSION system privileges
2. Select privilege on certain user tables as object privileges
then I put all those users in this role.

So, what should I have least for privileges of user PUBLIC then, if I
ask the question in another way?

Cheers!

Gary

PUBLIC isn't a real user, it is a dummy user. It is from the days
roles didn't exist. You can't connect as PUBLIC. Hence, if you don't
grant privilege to PUBLIC nothing will happen. I'd suggest you would
leave public alone. Simply don't grant privilege to public.

Sybrand Bakker
Senior Oracle DBA

Jul 19 '05 #2

by: Alex | last post by:

I am trying to write an Exit module for the Certification server in VB.NET and I cant get the module to be recognised by the Certification MMC snap in. Its function is to capture Serial Numbers of...

.NET Framework

198

tough choices

by: Sy Borg | last post by:

Hello: We are designing two multi-user client server applications that performs large number of transactions on database servers. On an average Application A has a 50% mix of select and...

DB2 Database

It's tough one!

by: Kennedy_f | last post by:

I did better in terms of score on this one than 291, but I found it much harder. Wordings of questions are difficult like the rest, but the DNS and CA scenarios were very tough to figure out. Take...

Microsoft Access / VBA

Tough security question using System.Security.Cryptography.RijndaelManaged.

by: Andrzej | last post by:

Hi, I have to figure out why we have a problem with special characters in encrypted usernames and passwords. Case: Username: r&bgeorge Password: tigger

C# / C Sharp

Tough redirection question

by: Dot net work | last post by:

Hi, Is it possible to do a form POST and also redirect to a different url, using code behind? I don't think response.redirect will work because that doesn't post form data. I don't think...

ASP.NET

Tough ImageList Question

by: Just Me | last post by:

If I add an image to an imagelist using imageList.Images.Add... And use it with a tree node tn.ImageIndex = imageList.Images.Count-1 This is the actual code:...

Visual Basic .NET

Tough question on database NULLs.

by: Karen Hill | last post by:

Suppose you have a textBox control. It is empty and you send the this.textBox1.Text.ToString() value into a database. The control does not send a NULL but instead a "". What is the _CORRECT_...

C# / C Sharp

A real tough one

by: kev | last post by:

Hi folks, I am halfway finishing up my project when i was bogged down with a request, something than i can barely chew. Let me start on straightaway. I have created a database for equipments,...