A schema describes the structure of various elements like tables, fields, objects, attributes, etc. for example for a database or a directory.

learn more… | top users | synonyms

18
votes
2answers
15k views

How can I do a dump of only the table structure in PostgreSQL?

In a similar vein to this question, how would I do a schema-only dump in PostgreSQL?
11
votes
3answers
7k views

How safe are Windows Active Directory Schema Updates?

I'm trying to get a better understanding about how Active Directory handles Schema updates, specifically how safe the procedure actually is given how critical AD is and given the range of situations ...
11
votes
1answer
11k views

Where does Active Directory-integrated DNS store its data?

This has been bugging me for a while. We all know Active Directory is a LDAP database. We also know that the Windows DNS service, when running on a domain controller, can store its data in AD ...
7
votes
3answers
4k views

Where do I store sensitive data within Active Directory?

I am essentially storing a private key (Hash) in any of the OctetString attributes within Active Directory. My question is, what attribute is secure by default and makes sense to keep private data ...
6
votes
3answers
4k views

SQL Server 2008 default schema not being respected?

We just copied a SQL 2008 database over to another server, for testing purposes. The typical user that logs in uses some objects in a certain schema. Let's say it's user foo and schema bar. foo's ...
6
votes
2answers
103 views

Is it possible for a schema change to not replicate, and a object that uses that schema arrive at a DC?

I'm trying to understand the risk of updating the schema of a very large AD forest, where the schema has not been on every DC, and then an object that uses that schema object is replicated An example ...
6
votes
2answers
1k views

Where can i find the latest unattended.xml schema (xsd)?

I'm working with Windows Server 2012, Windows Deployment Service (WDS), and Windows Assessment and Deployment Kit (ADK). I created a base unattended.xml file. When I go to edit in an xml editor it's ...
5
votes
2answers
2k views

Active Directory and Apple's Workgroup Manager

I thought I'd share my experiences here. I work for a small business with only ~20 users. I wanted the ability to use managed client preferences to assign things like the software update server. ...
5
votes
0answers
291 views

AD custom attribute of type numerical string crashes MMC when updated

I am using windows server 2008. I have a domain with one domain controller (this is a dev environment). I edited the AD schema and created a custom attribute called TestAttribute2 (the LDAP name is ...
4
votes
8answers
4k views

One Database vs. Multiple Databases

I need to design a system which represents multiple "projects", one per client in SQL Server , something similar to StackExchange... same data model, different sites (one per customer). Each project ...
4
votes
4answers
8k views

Moving a table to a different schema in Oracle

How do I move a table from one schema to another? It's a fairly large table, so the following query would take ages to complete and need huge disk space: CREATE TABLE newschema.mytable AS SELECT * ...
4
votes
1answer
304 views

SQL 2005 Security - Users: What are they used for? (and other various questions)

I am not a DBA and so dont really know anything about SQL 2005 security settings, etc. I am attempting to set up an empty copy of our database by generating the full database from SQL Management ...
4
votes
1answer
407 views

What are best practices to store delegated permissions in OpenLDAP?

My network's core user database is managed by OpenLDAP. Recently we need to introduce a possibility for one user to act on second user's behalf. As all application-related rights and permissions are ...
3
votes
2answers
2k views

Please help - Schema/RID master is unavailable and cannot connect to it via ntdsutil

I am in serious need of help. I had of 2 domain controllers and one currently went down last night indefinitely. I have one DC holding up the entire domain. Kinda in a panic. Our servers are running ...
3
votes
3answers
666 views

Active Directory examples of hierarchy

i am in the process of restructuring the hierarchical structure of the local active directory server of the institution i am working for. I was wondering if anyone knew of any place i could find best ...
3
votes
2answers
2k views

Custom attributes in Active Directory - determining usage/function and possible removal options?

I've bumped into a highly-customized Active Directory environment (2003 FL) that's got me wondering if there's any particularly easy way to figure out what a custom attribute's function is, and what, ...
3
votes
1answer
455 views

Adding apple.schema from OS X Lion Server fails

When I try to add apple.schema to my OpenLDAP running on Debian this is the error I get; root@directory:~# ldapadd -Y EXTERNAL -H ldapi:/// -f apple.schema SASL/EXTERNAL authentication started SASL ...
3
votes
2answers
288 views

SQL Server: explicit rights to schema?

When giving permissions to certain Schema in SQL Server, I want to deny some operations from certain users. Do I have to explicitly deny these, or is it so that when user gets a permission to this ...
3
votes
1answer
1k views

Migrating to Windows Server 2008 R2 Domain Controllers - a few Questions/Issues

Ok so here's our setup: We have 2 Windows 2003 Domain Controllers. I am trying to replace them with Windows 2008 R2. The 2003 servers are named DC01 and DC02. The 2008 R2 servers are DC1 and DC2. ...
3
votes
2answers
5k views

Unable to modify schema in OpenLDAP using run-time configuration cn=config

I'm having trouble modifying the schema of an OpenLDAP installation using the run-time configuration (cn=config). What I'm trying to do is modify existing attributes and add new ones to a custom ...
2
votes
4answers
162 views

Autogenerate a PDF or image of all the database tables and columns in a MySQL database?

I want to be able to create a PDF or an image of a MySQL database. It should have one box per table and each box should list all the columns in the table. I don't need lines going between various ...
2
votes
1answer
101 views

Advantages of auxiliary classes when extending Active Directory schema

I need to add some attributes to the user class in Active Directory. I see that to do this it is either possible to add the attributes directly to the user class, or to create an auxiliary class ...
2
votes
1answer
122 views

Changing LDAP schema casts Confluence AD integration unoperable

I have had our instance of Atlassian Confluence configured to be integrated with our Active Directory. In AD, all the users were being created under default Users folder in Active Directory Users ...
2
votes
2answers
723 views

How do you handle the task of changing the schema of a production MySQL database?

One of the biggest complaints I have heard about MySQL is that it locks up a table if you try to change its schema like adding a column or adding an index. By "locking up the table" does it mean I ...
2
votes
1answer
78 views

Testing for Active Directory Schema modification (not upgrade)

I am trying to test a schema modification. That is i need to add one of the attributes to global catalog by modifying schema , initially in a lab which is exact replica.My questions are below; -> ...
2
votes
1answer
415 views

Using LDAP to store customer data

We wish to store some data in 389 Directory Server LDAP that doesn't fit that well into the standard set of schema's that come with the product. Nothing too amazing, things like: when the customer ...
2
votes
1answer
253 views

OpenLDAP schema and attribute for account type

We have different account types: Personal - For employees Sponsored - For users that are affiliated with the organization but not official employees E-mail only - Only for e-mail usage (campaigns, ...
2
votes
1answer
65 views

custom ldap schema to hold expiry dates and statuses

I need to store account creation and expiry dates in our existing ldap. None of the standard existing schemas seem to quite fit the bill, not even ppolicy or samba. The answer I've come across so far ...
2
votes
3answers
13k views

How do I grant a database role execute permissions on a schema? What am I doing wrong?

I am using SQL Server 2008 Express edition. I have created a Login , User, Role and Schema. I have mapped the user to the login, and assigned the role to the user. The schema contains a number of ...
1
vote
2answers
604 views

Server 2003 R2 Schema Update

I have some questions about updating our Active Directory Schema. Right now We have 4 Domain Controllers across 3 sites. They are all running Windows Server 2003 with SP1. None of them are R2. They ...
1
vote
2answers
353 views

AD - storing last 4 of employee social sec number as the employeeNumber attritubte?

I am currently working on scripting some of our access at work and would love an easy way to enter and retrieve the last 4 of a user's social sec number. It's the primary way we identify people that ...
1
vote
3answers
10k views

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
1
vote
1answer
1k views

What's the required to make a normal user can create schema on PostgreSQL?

I created a new database test and created user 'eonil' with this command: CREATE ROLE eonil LOGIN ENCRYPTED PASSWORD 'password' NOINHERIT VALID UNTIL 'infinity'; on my PostgreSQL. I run psql -U ...
1
vote
1answer
87 views

services scheme diagram [closed]

We have many web-services, applications and sites that are hosted on 4 different server farms, multiple urls, A records, sub-domains, HTTP redirects and more. What is the best way to start and create ...
1
vote
1answer
917 views

Server 2008 R2 schema changes - any since RC?

I know that there were schema updates in the 2008 R2 beta and more in the 2008 R2 Release Candidate. Does anyone know if there are any additional schema changes required for 2008 R2 RTM? I haven't ...
1
vote
1answer
946 views

openLDAP how to remove the nis schema from the current configuration

openLDAP 2.4 Ubuntu 14.04 I have found this question dn-based linux groups from ldap. I am trying to include the rfc2307bis schema, but it seems the nis schema must be removed from the configuration ...
1
vote
1answer
48 views

Is this normal or due to bug in mongodb?

I am new to mongodb and i installed it on xen para virtual vm and when given command "mongo" terminal freezed and on the top output command mongo is taking almost 100% CPU. Is this a bug,or does ...
1
vote
1answer
363 views

ActiveDirectory lastLogonTimeStamp Inactive

In joining a new company, I have inherited it's history. I find that the User and Computer Object property lastLogonTimeStamp is not available. I have checked that the AD Schema version is 2003 R2, ...
1
vote
1answer
685 views

Where is “Custom Attribute 14” in AD Schema?

I'm getting the following error when writing to Active Directory attribute 14 00002082: AtrErr: DSID-03151314, #1: 0: 00002082: DSID-03151314, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att ...
1
vote
1answer
4k views

How to change OrganizationName after setup /p

I am working on cloning our primary AD DC to create a development environment. I have exported the relevant data from AD using ldifde but in order to import it on the new server, I need the Exchange ...
1
vote
1answer
3k views

How to backup a specific SQL Server Schema's table?

In my SQL Server database, I have multiple schemas. I would like to backup only a specific schema's tables to a format that can easily be restored. Example: [dbo].[Trucks] [dbo].[Cars] ...
1
vote
1answer
1k views

OpenLDAP cannot add new schema

I'm trying to add new schema to my OpenLDAP server. The version of slapd is 2.4.23. I'm using Debian 6. If I understood it well, slapd 2.4+ uses OLC configuration with (cn=config) by default for this ...
1
vote
2answers
354 views

Looking for advice on LDAP objectClasses for syncing with Google Apps

I am setting up an OpenLDAP server on Ubuntu so that this will be the authoritative user database for authentication. I'm going to be using Atlassian Crowd with it so that Google Apps can then use SSO ...
1
vote
1answer
61 views

Is there a “rigorous” method for choosing a database? [closed]

I'm not experienced with NoSQL, but one person on my team is calling for its use. I believe our data and its usage isn't optimal for a NoSQL implementation. However, my understanding is based off ...
1
vote
1answer
1k views

Unable to add schema in OpenLDAP using run-time configuration cn=config

I have the following ldif file which I am trying to load into openLDAP: Custom schema being created for the Monas project dn: cn=testSchemas,cn=schema,cn=config objectClass: olcSchemaConfig cn: ...
1
vote
1answer
535 views

LDAP schema design

I am pretty new to LDAP & trying to design a schema for a particular need. I have a Support Organization. There are three levels P1 - lowest permissions P2 - middle P3 - highest permissions. I ...
1
vote
1answer
1k views

Is there a maximum number of schemas allowed in SQL Server 2005?

What is the maximum number of user schemas one can create in a single SQL Server 2005 database? Is this figure different on SQL Server Express vs SQL Server Standard? I've searched the MSDN ...
1
vote
1answer
920 views

AD Schema updates, Exchange 2007 SP3 == Server 2008?

In terms of schema updates does 'Exchange 2007 SP3' adprep /forestprep and 'Server 2008' adprep /forestprep do the same thing? I'd like to add a 2008r2 DC to an existing 2003-level forest (which ...
1
vote
0answers
65 views

Samba 4 schema extension - restart needed?

I'm integrating a custom schema in a Samba 4.2 server. This is working quiet well (using ldbmodify) but I wonder if it is necessary to stop the samba service before running ldbmodify. The Samba Wiki ...
1
vote
1answer
150 views

Unable to change schema of a Publication Database using TSQL (Ready-roll): being forced stop replication

I am trying to apply schema changes using T-SQL (using Ready-Roll database source control tool with Octopus Deployment) to a Publication database however it is forcing me stop Replication for the ...