Hiding Database Views

Oct 17, 2001

Help Please!
How can I hide databases from users that do not have permission to log onto them in the SQL Enterprise Manager.
Thanks in advance for the help.
-Rich

View 3 Replies


ADVERTISEMENT

Hiding The Database List From A Certain Usergroup

Jun 18, 2007

Is there a way to limit what user will see in Enterprise Manager? Iwould like them to only see there db's and not all them.

View 5 Replies View Related

Are Embedded Views (Views Within Views...) Evil And If So Why?

Apr 3, 2006

Fellow database developers,I would like to draw on your experience with views. I have a databasethat includes many views. Sometimes, views contains other views, andthose views in turn may contain views. In fact, I have some views inmy database that are a product of nested views of up to 6 levels deep!The reason we did this was.1. Object-oriented in nature. Makes it easy to work with them.2. Changing an underlying view (adding new fields, removing etc),automatically the higher up views inherit this new information. Thismake maintenance very easy.3. These nested views are only ever used for the reporting side of ourapplication, not for the day-to-day database use by the application.We use Crystal Reports and Crystal is smart enough (can't believe Ijust said that about Crystal) to only pull back the fields that arebeing accessed by the report. In other words, Crystal will issue aSelect field1, field2, field3 from ReportingView Where .... eventhough "ReportingView" contains a long list of fields.Problems I can see.1. Parent views generally use "Select * From childview". This meansthat we have to execute a "sp_refreshview" command against all viewswhenever child views are altered.2. Parent views return a lot of information that isn't necessarilyused.3. Makes it harder to track down exactly where the information iscoming from. You have to drill right through to the child view to seethe raw table joins etc.Does anyone have any comments on this database design? I would love tohear your opinions and tales from the trenches.Best regards,Rod.

View 15 Replies View Related

Run 1 Query Against All Views In Database

Jul 16, 2014

In SQL server 2008 how can I run the same query against each view in that database?

One database about 75 views.

Or even something like
Select 'yes' from view
Where shipping_status = 'delayed'

And return a list of view names so I know which views to query against.

I ran

Code:
select name from sysobjects where type = v

And got a list of my views. How can I now run my SQL statement against the list to see which views contain the info?

View 1 Replies View Related

Database Views Hierarchy

Feb 2, 2006

Hello:In my SQL Server databases I have complex related tables and views.There is any tool which allow you to see (print) this complex hierarchy ofviews and tables as hierarchical tree?Thanks,GB

View 3 Replies View Related

Select From Database Without Grid Views Etc

Jul 9, 2006

Hi,

I want to be able to select data from a database without using grid
view etc. I can set up a connection and bind it to a grid view but I
would like to do some data processing without showing it. Something like

select id from table where name = "x"
store id in idvar
store the row count to a variable rowcount
if rowcount > 0
    select name from table2 where id = idvar
endif

etc

I can see how to set the sqldatasource select command but not how to run it and get results out of it. Please help

View 1 Replies View Related

Using One Database Call To Populate 8 Grid Views

Apr 23, 2008

Hi
I'd like to be a little more efficient in my approach when using databases. Although my site is very simple with a low hit rate expected, I would still like to learn the best methods in designing server load conscious code.
Basically, I have a page where I'd like to show events broken down into days of the week (Monday - Sunday). All the events contain the same data and only difference being the day. Right now, the only way I know how to make this work is to create a unique sqlDataSource (select * where Day = Monday) then assign it to a ‘Monday’ grid view. I then repeat this same process for each day of the week.
As the data is always the same, is there a way to make only call to the database returning all the data, then close the connection and then separate the data there after. To me this seems to be a much more efficient way to manage the data???
Thanks for any help/supportRichard

View 4 Replies View Related

Alter All Objects In A Database / Views / Triggers

Apr 20, 2015

I am trying to replace object name in views , triggers, stored procs, UDF,TVF etc.I have created a automated script to replace 'dbo.Cust' with 'dbo.Customer' in all objects and generate script as ALTER Statements. some objects are still scripted out as Create. Reason is it has some extra space in between

CREATE TABLE #test1(
[NAME] [nvarchar](128) NOT NULL,
[DEFINITION] [nvarchar](max) NULL,
[DEFINITION_bk] [nvarchar](max) NULL,
[type] [char](2) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

[code]....

View 5 Replies View Related

No Views After Creating A Database With Restore From Backup

Nov 13, 2007

Forgive me if I'm asking a simple question, but I'm new to database administration
I'm trying to migrate a database from a server running Windows 2000 Server and SQL Server 2000 to a new machine running Windows Server 2003 and SQL Server 2005. I moved a copy of a recent database backup file to the new server, and created a new database with Restore From Backup. The tables seem to have restored fine, but my views are non-existent. Has anyone seen this problem before, or does anyone know of something I may have skipped?

View 3 Replies View Related

Is There A Way To Give Someone The Right To Create Only Views And No Other Objects In A Database

Feb 25, 2008

Is there a way to give someone the right to create only views and no other objects in a database? Currently I have given the individual ddladmin database rose, but would rather be more restrictive?

View 1 Replies View Related

How To Display List Of Tables && SP && Views In A Database?

Aug 16, 2007



Hi
In SQL Server 2000 & 2005

How to Display list of Tables & S.Ps & Views in a Database?

Please advise

Thanks

View 4 Replies View Related

Searching The Keywords In A Collection Of Views Present In A Database

Jun 17, 2008

Hi All,
i have some views in my database, and these views are having some columns,i want to know particular column name to be there in particular view.
For example ,just like functionality of sp_search_code 'Keyword'.
like this i want to search in views .
or else please let me know  sp_search_code 'Keyword'. was used for views also.
Thanks and  Regards,
G.JaganMohanrao.
 
 
 

View 2 Replies View Related

How Can I Get The List Of Tables And Views Together In The Database By The Dbconnection.getSchema()

May 3, 2006

I have tried SqlConnection.getSchema("Tables"). it returns me a list of all tables while getSchema("Views") returns me the views in the form of DataTable. But can we have a way to get them together in the same DataTable as a return result? because I want to read the rows by  DataTable.CreateDataReader() later.

View 2 Replies View Related

Avoid Cross Database Views In Data Warehouse

May 4, 2007

We have a relational database (rd) and a data warehouse (dw). This dw has a table (tw) with all key fields (dimension keys) and metric related (measures) fields. This table is populated with monthly data each month. The tw is joined to various look up views present in the dw to obtain name fields from rd. The DBA wants me to remove the look up views. I now have following 2 options that I can think of –

1)Further de-normalize the tw and store the name fields as well. However, there are two issues with this option –

a.The size of tw will grow tremendously.
b.We are storing monthly data and the values in the name fields may change after some time. Then we will have to put in additional views/objects to obtain the latest name.

2)Using ETL, obtain the copy of rd tables overnight in dw. We will then join tw with these tables and there will no longer be cross database joins. However, this will be a burden on maintenance and support.

As of now these are the possible options I can come up with. Which one would you suggest and why? If you have another option, please let me know.

Thank you all in advance,

sajmera

View 1 Replies View Related

Script All Database Tables,views And Stored Proced

Jun 24, 2008

what's the easiest way to script all table,views and stored procedures?

I would like to script them like from ssms i right click on each one and choose script table as --- but how can I do it for all of them at once?

View 1 Replies View Related

Large Views Vs Multiple Small Views

Sep 6, 2007

Which is more efficient? One large view that joins >=10 tables, or a few smaller views that join only the tables needed for individual pages?

View 1 Replies View Related

How To Find Out The List Of All Tables And Views Owned By A Particular User In Any Database?

Oct 15, 2001

How to find out the list of all tables and views owned by a particular user in any database by querying the system tables?Thanks.

View 2 Replies View Related

Grant User Group Select Access To All Views In Database

Sep 24, 2013

I'm trying to grant a user group select access to all the views in a database. I already made a query which creates a result set whit the SQL Syntax I (displayed below) need but it seems to be impossible to get this result set executed after creation.

use [AdventureWorksDW2008R2]
SELECT
'GRANT SELECT ON [' + SCHEMA_NAME(Schema_id) + '].[' + name + '] TO [DOMAINGROUP]'
FROM sys.views;

View 5 Replies View Related

SQL Server Admin 2014 :: Script To Find Nested Views In A Database

Oct 7, 2015

Any easy way to find if there are any nested views existing in the database?...using SQL server 2014...

View 1 Replies View Related

SQL Server 2014 :: Query For Listing Views In A Database Involving Tables From Other Databases?

Oct 19, 2015

script to get the list of views in a database, involving tables from other databases?I AM using SQL server 2014

View 2 Replies View Related

Hiding A Zero Value

Jan 11, 2007

How can I hide or suppress the 0-values (zero) in a report?

View 8 Replies View Related

Recompiling Views That Reference Other Views

Jun 28, 2007

Hello.

Newbie here. I've only been using SQL for about a year now and have some minor questions about sql objects that reference other objects.



We have some views which reference other views in the joins. I will call one the primary view and the one being referenced in the joins as the secondary view.

Recently we made changes to the secondary view.

After which the primary views which referenced it would not work because of this change and had to be 'refreshed' by using drop/create scripts which essentially just dropped it and recreated the exact same view. I do not recall the exact error message that was returned other than it seemed to suggest that it could no longer see the secondary view since it had been changed. Nothing in the primary view was changed in any way, just the secondary.



Some here where I work have suggested off hand that this was a recompile of the primary view because the contents of the secondary changed.

My questions are:

1. Exactly why did this happen and is there a proper name for it when it does?

2. The same problem does not seem to occur when we have stored procedures referencing views in the joins which had just been changed. Why is that?



Thanks for any help on the matter. I greatly appreciate it.

View 3 Replies View Related

Quicky : Views Of Views Of Views

Feb 22, 2007

Hello,

to make a report easier I'm developing it using a view of joined views of joined views.

Is there any significant performance penalty as opposed to just having one big select?

Cheers.

View 1 Replies View Related

Hiding Particular Objects

Aug 1, 2000

Hey guys,
Is there any way to hide a particular object(table,sp,tr etc) from
a particular user?

we are developing softwares for the clients..and Once we install our product we dont want the clients site guys to go and delibrately view the data from sql server but through the front end. Is there anyway that i can do that...?

For Eg..the front end codes are capsulated as DLLs so that no can view the code.. Like that for SQL Server..can we do that kinda stuffs to prevent them?

View 5 Replies View Related

MS SQL Hiding Behind Access

Dec 7, 2005

Hi guys

We have a helpdesk application which is based on an MS SQL database, and which runs with a rather large and complicated C# based interface. We don't have the code for this, so we can't customise it. Long story short, what we want is to create an interface in Access (or similar) which accesses the same database as the helpdesk suite, and allows reading AND writing, and some rather complex operations (which SHOULD be fairly simple to do in SQL).

Unfortunately, I have been given this project, and I know about as much about Access and SQL as I do about Ghengis Khan's fashion sense.

I will follow with more information as required, but I'm going to need a lot of help with this one. First things first, is Access the way to do this? Is it going to be easier to create a new Access DB and synchronise it with the SQL, instead of both applications using the same database?

The only way I can get Access to interrogate the SQL database is to create a Data Access Page - is this the correct starting point? The only problem is that this seems to only offer HTML, and is far from being a friendly interface, at least not to me.

I know that I currently have no grounding in physics and I'm trying to build a space station, but any advice that you could give me would be much appreciated.

Thanks guys!

View 4 Replies View Related

Hiding The DB Design.

Feb 3, 2004

Hi all,

I am going to install my application at my Client's place.

I do not want them to know about my DB design and also i have a lot of master information that I dont want the Client to view.

The Client insists that he would have the Super Administrator user ids and passwords (ie. "sa" - user).

Is there any way i can encrypt my DB design and the data in the DB.

Or is there any other way of restricting the Client from viewing my DB design and data???

Thanks

Vishal

View 5 Replies View Related

Hiding NULL

Mar 29, 2006

In SQL 2000 Query Analyzer, you can set up the text output pane toleave null values blank.That could give you this (assuming it's set to comma-delimited) --CREATE TABLE #Test (A int, B int)INSERT #Test SELECT 1,2INSERT #Test SELECT NULL,4INSERT #Test SELECT 5,NULLINSERT #Test SELECT NULL,NULLSELECT * FROM #TestA,B1,2,45,,I can't figure out how to set up 2005 Management Studio the same way.I can only manage to get outputs like this, with "NULL" instead ofempty fields --A,B1,2NULL,45,NULLNULL,NULLHow can I get rid of the NULLs?Thanks,Jim

View 2 Replies View Related

Hiding Data

Jul 20, 2005

Hi,I am intetrested to know if there is a way to hide the information in aspecific column in my table. SQLServer 200. Something like a passwordprotection were you only see *****. I have a DBA but want to hide salaryinformation from him that is stored in the database.Any suggestionsThanksElmo

View 3 Replies View Related

Hiding A Table

Feb 28, 2008

Hi,

I am designing a report with a few tables in it which i selectively want to hide if there is no data to display in them.
The tables hide themselves but leave behind a big void without compressing the fields beneath them.

Is there anyway to make sure that the tables are hidden and it compresses the space which it would have otherwise occupied?

The two methods i have tried are:

1. Put an expression in the visibility property and set it to true if the row count is zero
2. set the expression in the NoRows property to =""

(both without luck)

Any suggestions would be greatly appreciated.

Regards,

Ash

View 4 Replies View Related

Hiding Parameters

Jan 11, 2008



Hi There,

I am fairly new at RS, and have a question about showing/hiding parameters :

What i would like to do is have one report, with the parameters :

Report By : (Date/Week)
Buisiness Stream : (Spares/OEM)
Start Date : (Date)
End Date : (Date)
Start Week : (Start Week Num)

End Week : (End Week Num)

What I would like to do is show the 'Start Date' and 'End Date' when the Report By value = Date

OR

Show the 'Start Week' and 'End Week' parameter when Report By value = Week.

Can someone help me with this?

Thanks

Jamie

P.S. If its not possible to hide the fields, could i grey them out??

View 3 Replies View Related

Hiding Sub Report

Jan 9, 2008

I have main reports and also sub reports in the same project [folder]. I don't want to show sub reports in the reports drop down list. Can you please let me know how to do it?

View 1 Replies View Related

Hiding Reports

Jul 23, 2007

Is there a way to hide reports before publishing and then hiding reports via the Report Manager? We have some subreports that before we publish, we would like to set a flag to hidden so the Report Manager will know after the deploy that this report is to be hidden.



Thanks for the information.

View 4 Replies View Related

Hiding A Subreport

Jul 24, 2007

We have a parameter that takes the values of "Yes" or "No" (non-queried). If the user chooses "Yes", we want the subreport to display, but remain hidden on "No".



In the expression for visibility, we have the following:
=IIf(cstr(Parameters!Heading.Value = "Yes"),False,True)



When the report runs we get the following error: "The input string was not in the correct format."



Has anybody seen this before?



Thanks for the information.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved