Hide Logins:-)
Jul 7, 2004Hi knights,
Pls show me the way to prevent the other users seeing all logins when they logon into SQL Server. Thnks in advance!
ADVERTISEMENT
Lost SQL Logins, But Still Have DB Logins - Script To Recreate SQL Logins?
Jan 21, 2007ok, first, I know... I forgot to run a backup of the master database, and I forgot to run a script to caputure logins. Not that that is out of the way... I need to recreate the logins under the Securities tab below the databases. All the company databases have the user names and passwords assigned to them, but they are not able to login, because they are not able to authenticate to the SQL server first.
Is there a script that someone has that will copy the company database security info for the users and recreate them in the SQL security tab?
I know that I can rebuild them manually, but I need to delete them first in the application software, then delete them from the databases, and then recreate them in the application software... and as simple as that sounds... it is a slow moving process.
Any assistance would be greatly appreciated.
Thanks,
John
Export Logins To Server With Already Existing Logins
Jul 17, 2001Hello,
I would move a Database to another server. I try to use DTS but I have problems with this process because DB have big tables, I think. I try to use DETACH and ATTACH procedures but logins doesn't export. And more, in new server there are already logins from another DBs.
What's the best way to solve this problem?
Please, help
Thanks
Moving DBs From SQL Server Logins To Windows Logins
Apr 3, 2007I am a systems analyst and work with an app that runs against 2 SQL Server DBs. Though I have some familiarity with SQL Server and SQL, I am not a DBA.
The app executable is tied to a Windows service.
When we install the app, we run a process that builds 2 dbs to include:
Tables, indexes, stored procedures, views and user accounts.
SQL Server is set up for mixed mode authentication.
Normally, the dbs run off the local db user accounts which are tied to local logins with the same names.
We have a client that wants to remove our standard logins so that they can run on only a Windows login.
I know I should be able to tie the db users to a Windows login.
And I can do the same for the service.
But I am at a loss as to how to get this done.
How do you associate db users with a Windows login?
When I have tried sp_change_users_login I get an error that the Windows login does not exist. (Though I have added the Windows account to the DB.)
Hope this all makes sense.
Hide Row When The Sum Is Only In 1 Row
Nov 14, 2007Hi...
I whant to hide this
Ex.
=Fields!D_FAMILIA_MIS.value
This fields have 4 group and i whant to sum only group added just over 1 line as sub group
I do not speak English well, so it does not lead bad
MC
OVLA
How To HIDE SQL Server On LAN?
May 26, 2007Hi everybody
In my web application I am using SQL Server 2000. But as we all know, its presence in the network is visible to all the clients in the network. Anybody who has SQL Server client installed and knows the password of the database would be able to access DB remotely and this is what I don't want. I want user to access my database only when they are loggedon on physically (directly) on the machine on which SQL Server is installed.
Your replies are awaited.
Thanks in advance.
Regards,
Zulfiqar Dhuka
How To Hide Sme Tables In DB
Dec 24, 2001Configuration:
Windows2000 , SQL7
Three people have administrative priveleges (with priveleges Enterprise admins)
There is special DB in SQL7
Some tables should be hidden from 2 admins (they should be unable to read information from these tables)
Is it possible?
And if it is possible, How to do it?
Thank you very much
Merry Christmas
Happy New Year
Seasons greetings
How To Hide A Member?
Jan 14, 2005I have a dimension named Products with the following hierarchy:
Type
Sub Type
Product
Due to requirements I want that a particular product, whose name is, say, "XYZ" should not be displayed when the user drills down to the lowest level i.e. the Product level.
I tried playing with the Advanced Properties tab but could not make any progress and thus will be grateful for help.
Thanks.
Hide Some Parameters
Sep 21, 2005Hi,
Is it is possible to hide some parameters in report? Also it should be possible to pass values to this hidden parameters from the application. When I did this through Report Manager, some error message like ' the parameter 'XXXX' is read-only. ....' appears.
Thank You
Sreeraj.P.T
How To Hide Subtotal
May 28, 2008Hello,
I have a matrix with subtotal.
I want to hide or show the subtotal by a parameter.
The header of the subtotal is not a problem since it have the "visibility" property.
The problem is that when I'm clicking on the green rectangle to go to the subtotal area itself - It doesn't have the "visibility" property.
So I don't see the header but I see the subtotal date itself.
Any idea on how to resolve this?
Thanks.
Hide Textboxes
Feb 25, 2007Hello Everyone. I need help again.
I have a reports made in VS business intelligence project with a lot of parameters. So it means it automatically creates textboxes of that parameters. I want to hide those textboxes. Pls help.
Thanks
-Ron-
Sub To Hide Query
Feb 21, 2008How can I add a sub in my query so that it can hide and need password to view or edit?
View 6 Replies View RelatedHide/unHide
Dec 26, 2006dear All,
I want to make a Report with attractive selection parameters.
That I mean, there is a parameter, Tparam (Time Param) which will activate other parameters (3 parameters: TimeA_1, TimeA_2 & TimeA_3. These selection values have been registered in the "Aviable values => non-queried".)
when Tparam selected TimeA_1 then Parameter for TimeA_1 will activated (and the others will be disappeared/hidden), vice versa for the other control (TimeA_2 & TimeA_3)
any idea to do that?
thank you...
Trying To Hide A Rectangle
Sep 21, 2007Hello,
I have a rectangle which contains a chart. Most of the time, the chart has data, so the rectangle should be visible. Sometimes, however, the chart may have no data (zero records). In that case, I would like to hide the rectangle.
Is there any way to "query" data from the report's recordset to see if a certain condition is true.. if so, use that to control the visiblity of the rectangle?
I have one column in the recordset that has many values... the chart will only display data if certain values are returned in the recordset.
Thanks for your advice!
How Can I Hide Whitespace
Mar 28, 2008
I am currently working on a rather simple report, it cosists of a table with two columns
The first column contains Employee Names, and the second column contials details of what the have worked on
I have made the second column invisible, and can be made visible when the eployee name column is expanded.
The problem that i am having is that when the second column is collapesed, it still leaves whitespace, in the first column, of how ever many rows that are contained in the second column, is there a way, I can get rid of that whitespace?
Thanks
Chris
Hide Row When Value In 'X' Column Is &&<= 0
Nov 15, 2007
I'm creating a report that is grouping the rows per year and month, as it does this there are certain rows that show up that I would like to hide since the value in one of the columns is < = 0. For the purpose of my report I don't needs these rows to be illustrated. How can I do this?
Thanks,Alex
Hide Duplicates
Sep 6, 2007I trying to create a report that looks like this:
Item Shipped OnHand PO# DueDate POQty
1234 0 0 111 8/01/07 12
222 8/08/07 12
333 8/16/07 12
2345 4 0 444 8/04/07 24
I pull back all the data in a single query and the result looks like this...
Item Shipped OnHand PO# DueDate POQty
1234 0 0 111 8/01/07 12
1234 0 0 222 8/08/07 12
1234 0 0 333 8/16/07 12
2345 4 0 444 8/04/07 24
Now I can use the Hide Duplicates property to fix the Item column since the query groups on item guaranteeing uniqueness. But that won't work for the Shipped and OnHand columns because adjacent items may have the same Shipped and OnHand totals. How do I hide the Shipped and OnHand values if and only if the Item is the same? Is this really a problem of hiding duplicates or do I need to break apart my query or find a sub-reporting solution?
Hide Aspnet_* Objects
Nov 23, 2007Hello, I would like to not have to see the aspnet_ tables and stored procedures that are created when using the Membership, roles, and personalization. Currently I have to suffer seeing the handful of tables and 40+ stored procedures in both the Visual Studio and the SQL Management tool. I have found that on a 2000 SQL Server I can execute a command that forces objects to be created as system objects. If I execute this before creating the objects they become system objects and I don't have to see them any longer. However, this trick does not work in SQL Server 2005. So, I would like to know either 1) is there an easy way to hide these objects or 2) is there a way to change the objects to system objects in SQL Server 2005? CodeGuy
View 5 Replies View RelatedCan I Hide Data From A SysAdmin??
Dec 7, 2001Is is possible to hide "salary" or other sensitive data from a person who is a Sys-Admin. My belief is that there is no way. Please correct me.....
Assumptions: SQL Service account has Local Admin privelege.
Sysadmin can do anything on local machine, including run scripts adding themselves to any default/instance of SQL on the machine.
Please direct me to any other source of information for this topic.
Thanks for your input
Hide System Objects In Ent Mgr
Jul 19, 2002Is there a way to not have system objects (tables, procs) display in Enterprise Manager?
View 1 Replies View RelatedHide Table View
Oct 14, 1999Hi,
How can I hide all the system tables so that only user tables show in table view.
Thank you very much!
John
System Tables And More - How To Hide Them?
Mar 9, 1999Hi everyone,
I've recently installed MSQL Server 7.0 Standart Version and every time I create a new database, system tables are created and are visible also. That means, I instantely get 18 tables, 20 views, 18 stored procedures and so on. Can I hide them??? I mean, my tables are all mixed with the system tables. If I can hide all the system tables and views and so on please tell me! Thanks.
Hide/encrypt Password In Sql Under EM?
Mar 1, 1999I am setting up several isql job in Enterprise Manager and as a cmdexec job I need to pass the user id and password( -P). I shtere any way not to pass this as text and perhaps hide/encrypt it since any one who opens the task scheduler and looks at the job can read the password?
Thanks.
DAvid Spaisman
Can I Hide Displaying A Certain Member?
Apr 25, 2006Hi,
I have a dimension called customers having the following levels:
ALL
Level 1 CustType
Level 2 Cust Rank
Level 3 Cust Name
Suppose that the possible CustTypes are "Potential", "Active", "Lost".
Is it possible to hide displaying Level 1 and below if the Custtype (Level 1) = "Potential"
Hide Folders In Report Mng
May 12, 2008Hi All,
I would like to control user access to my Report Manager.In detail,I would like to hide some report folders from certain users when they access the Report Manager.Some of the users are not suppose to see certain folders on the report manager,and some users are suppose to see all report folders.
How can I do this?.Where should I include this settings?
Hide Command Window
Feb 16, 2007I am using the SQLCMD function to execute a particular storded procedure every minute. The task schedular calls this batch file to run the stored procedure every minute. The issue is it opens up a command window every minute and is annoying. How can i run this job using sqlcmd and still not have the window pop up.
Is there a way to create a service that can run the batch files without the user knowing that it is running. I am trying to replicate what sql server agent used to do wth msde. i am using sql server express now.
Hide Rows In A Table
Oct 19, 2007hi, i have a table that returns all rows. But i need to hide the rows having the "Order"= false.But i don't wanna do it by querying in the dataset, i just wanna hide these rows."Order" is a column in my table. Does anyone know how this can be done?
Thank you
Hide Databases In SQL EM From Dbo Owner
Jul 20, 2005If i create a new SQL login and give that login db ownership for a test db.When that user adds my SQL Server through his own SQL EM, why does he/shealso see all other objects (databases, sql security logins, DTS, ...)?Is there a way for the user to open SQL EM but only see his/her db andnothingmore?Thank you
View 4 Replies View RelatedHow To Hide Collapsed Rows
Sep 13, 2007Hello,
In the report I€™m making I set the visibility property of the textboxes comprising a row to be toggled on by an item in the group header. I set the initial visibility to hidden, and initial appearance to collapsed. Now this worked fine, I get group headers with the sum of the records, that I can expand by clicking +.
The problem is that even though the collapsed rows are empty and the lines separating them from each other are invisible, they still take up space so the other group header (when collapsed) starts not right away, but after a space which is equal to the sum of the height of all the hidden rows.
All I managed to do is set the row property to €ścan shrink to accommodate contents€? and set the row height to 0.07937cm this helps but if the group contains 50-100 records the space between headers is quite big.
I do not know why, but I can€™t set the row height to 0.0cm. This problem also bothers me when I hide duplicates in group and the empty row is still visible in the report. It takes up space and the people using the report are complaining for the unnecessary lines that hinder reading.
Could anyone help me with this one?
Regards
Darius
Hide Column In Matrix
Oct 24, 2006I have a matrix that has the following columns:Date Shift Equipment1 Equipment2 Equipment3 etcBased on a parameter, i want to show/hide the Shift column. If the Shift column is hidden, i want to move the equipment columns over so there is no gap in the columns.I know you can do this in a table by hidding the whole column, but how do you do this in a matrix? when i try to hide the column the visibility option is not there, and when i hide the field, it leaves a gap in the report.Thanks for your help.
View 2 Replies View RelatedHide Database Design
Jan 7, 2007Hi
I wanted to see if Microsoft was going to address this problem
We as developers want to hide our database design (SQL Express DB)
We dont want to rely on the user rights settings to secure the design
Most of our clients have admin access which means that they can see the db design
We are happy for the design to be available on the server as change control should be given only on the server
I am perplexed how this hasnt been addressed
Your reply is appreciated
T
Hide Field From User
Oct 22, 2006I have an app that connects to sqlepress. When run the field are loaded from the db. There are some fields that I don't want some of the users to see. Is there a way to do this without hardcoding the 'username' in the applicaton ?
I looked at the explicit permissions for username for the particular table, but I don't understand some of the terms listed.
Alter
Control
References
View definition
Hide 'New Subscription' In The Explorer Bar
Jan 25, 2007Hello
We do not want the end users to know of the subscription capability. How do we hide 'New Subscription' link for a report.
Thanks