473,574 Members | 2,613 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How tough can I be for the user PUBLIC?

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
1 6113
ro************@ yahoo.com.au (Gary) wrote in message news:<17******* *************** ****@posting.go ogle.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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1843
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 newly created certificates. This is quite obscure and I cant really find any example code. On the face of it it looks pretty straightforward. ...
198
11437
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 update/insert/delete statements and application B has 80-20 mix of select and update/insert/delete statements. Being able to scale the databases as needed...
6
1520
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 your time on the questions. I used uecrtify exam simulation. Make sure you know exactly what they are asking for and think it through. You will not...
0
3540
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
5
1570
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 server.transfer will work because that doesn't redirect to a different url. I don't think HttpWebRequest will work because that doesn't redirect
4
2189
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: Win32.Shell.SHGetFileInfo(NodePath, 256, fileinfo, cbFileInfo, flags) tvFolders.ImageList.Images.Add(Icon.FromHandle(fileinfo.hIcon)) tn.ImageIndex = tvFolders.ImageList.Images.Count...
24
1354
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_ way (e.g. the way the C# language designers at MS would do it) to handle this situation. I know you could just test for a "" and then have code...
1
1287
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, meaning any new equipment bought will have to be registered and go through three phases which is Safety Level 1, Safety Level 2 and Safety Level 3....
1
188
by: Gary | last post by:
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
0
7720
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8044
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8230
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7810
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8096
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6451
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3739
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3749
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1056
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.