473,699 Members | 2,526 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

View permissions

Can I construct a restricted view and grant select access on it to a
user without granting select access to the underlying tables and views?
This seems to be an easy way to restrict a user to just 'his part' of
the database.

Nov 12 '05 #1
2 3229

"Robert Stearns" <rs**********@c harter.net> wrote in message
news:10******** ****@corp.super news.com...
Can I construct a restricted view and grant select access on it to a
user without granting select access to the underlying tables and views?
This seems to be an easy way to restrict a user to just 'his part' of
the database.

Yes, you can give users access to views without giving them access to the
underlying tables. That is one of the main benefits of views in DB2.

Note that views may or may not be read-only, depending on how they are
defined. For example, if a view is defined on a join of two or more tables,
it is always automatically read-only. The exact rules for what makes a view
read-only are stated in the SQL Reference. If they are not read-only, you
may or may not want to take precautions to prevent updates via those views.

Also, views may be based on other views, to as many levels as you like so
that it is perfectly possible to have a view of a view of a view of a view.
Be careful though: if your view is based on another view or table, if that
object is dropped, your view also disappears, automatically and without
warning.

Rhino
Nov 12 '05 #2
Robert Stearns wrote:
Can I construct a restricted view and grant select access on it to a
user without granting select access to the underlying tables and views?
This seems to be an easy way to restrict a user to just 'his part' of
the database.


Yes, of course.

That's one of the benefits of views.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #3

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

Similar topics

4
20930
by: Richard Holliingsworth | last post by:
Hello: I have an Access 2K form I built from a SQL Server 7.0 view. I want to lock certain fields in the database from users so they can see them on the views and forms, but NOT be able to edit them. I've looked in BOL, MS SQL Server web page and SQL Server 7.0 books and could not find how to do this. Any advise will be greatly appreciated.
3
21475
by: Mike | last post by:
I have never written a trigger before, but I have a couple of uses for them now so I am trying. I have a view that I created and I want to have this trigger, run anytime the view is run. I don't know if my problem is with the trigger or permissions on the view, right now I have given everyone permission to select and update on the view (just trying to figure this out). Here is the begining of my trigger. use OTB If Exists (Select name...
3
9735
by: wireless | last post by:
What is the best way to grant a user permission to create a view? I first created a role using enterprise manager but for the role I created it doesn't seem to offer that permission. It offers the basic stuff such as insert, select, and update. I could go in and use a grant create view sql statement I suppose but I'd rather do it through enterprise manager where it would be visible if I need to change it in the future.
1
1815
by: timc | last post by:
We are running SQL Server 2000 Developer Edition. I don't want to make the developers the sysadmin or even the dbo in the user databases. Is there a way to give them access to only view the permissions for the stored procedures in the user database without making them dbo? When I take them out of the db_owner role, when they open a stored procedure they no longer see the permissions tab. I would like for them to see the permissions...
1
2729
by: Kelly Prendergast | last post by:
Is there a way to allow users to see the design view of a table without having dbo permissions? Thanks
4
1853
by: sea | last post by:
I have a database in Access 2002 but I am unable to view code or write any modules when logged in with a limited user account using Windows XP, service pack 2 -- no problems when logging in as administrator, -- any ideas on how a limited user on Windows XP can access code and modules in Access 2002? Thank you very much.
0
1779
by: davebrad4d | last post by:
Please help me I am trying to port over some old 3rd party code (using XVT), and am using .net via managed c++. All my buttons and edit controls look great. However i can't get a virtual OWNERDATA listview working. I have tried extending the get_CreateParams with the LVS_OWNERDATA style but spy++ does not show that this works, also i never get the WM_NOTIFY message (i have extend the WndProc method). Please can someone tell me what i am...
5
2193
by: Grzegorz Danowski | last post by:
Hi I have two databases: Customers and Operations. In Customers database I have made a view based on a few tables from both Customers and Operations (left join - customers without any operations). In the same database (Customers) I have created a stored procedure based on the view. Finally I'd like to give to some users permission only to exec the stored procedure. Have I to add the users to Customers? If yes, please describe me how to...
1
1328
by: rdemyan via AccessMonster.com | last post by:
When users are setup in my app, the administrator can restrict the products that are available for viewing by the user. I have a table, Table 1, that lists the User Name, Product ID and Viewing Allowed (True/False) for each product. But here's the problem. What happens when new products are added? Administrators don't want to have to go in each time and activate those new products for viewing. How do I best handle this? I was thinking...
0
9197
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9054
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8941
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 most users, this new feature is actually very convenient. If you want to control the update process,...
0
8897
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7785
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5881
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4390
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3071
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2015
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.