Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [schema]

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

112 questions
2
votes
2 answers

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 can neither read nor write to the table? Sometimes…
Continuation
  • 3,080
  • 5
  • 30
  • 38
2
votes
1 answer

Manually (re-)create Active Directory schema objects msExchRecipientDisplayType and msExchRecipientTypeDetails from Exchange on Samba AD

Somehow, my Active Directory has "lost" (at least) 2 objects from the schema. msExchRecipientDisplayType and msExchRecipientTypeDetails are what I need to recreate. I believe they were lost, because my existing useraccounts have those properties.…
Alex Stragies
  • 409
  • 4
  • 12
2
votes
1 answer

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; -> What tests need to be done post schema change to…
Darktux
  • 827
  • 5
  • 21
  • 36
2
votes
1 answer

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 containing my attributes, and then attach the…
Paolo Tedesco
  • 1,296
  • 7
  • 16
  • 23
2
votes
1 answer

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 and Computers. We have decided to introduce cleaner…
Maxim V. Pavlov
  • 663
  • 3
  • 11
  • 29
2
votes
1 answer

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 is: "use a custom schema". Fine, but I can't seem…
Oliver Henriot
  • 123
  • 2
  • 9
2
votes
1 answer

Oracle- Can't access objects from other users schema

I have an oracle database with 2 users. I have created a table in one of the user accounts, but cannot access the table from the other account ("table or view does not exist"). It doesn't work when I prefix the table name with the username…
Lock
  • 1,637
  • 7
  • 26
  • 33
2
votes
4 answers

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 forgein keys or show info on default types or even…
Amandasaurus
  • 31,471
  • 65
  • 192
  • 253
2
votes
1 answer

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 joined are they currently active customer…
hellomynameisjoel
  • 2,172
  • 2
  • 18
  • 23
2
votes
3 answers

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 tables and stored procedures. I would like the Role…
Lewray
  • 143
  • 1
  • 1
  • 6
2
votes
1 answer

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, etc) Shared - For offices or departments Right…
Belmin Fernandez
  • 10,799
  • 27
  • 84
  • 148
2
votes
1 answer

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] [unknown].[Trucks] [unknown].[Cars] How can I backup only the…
Omar
  • 195
  • 3
  • 14
2
votes
2 answers

Why can't I grant select privileges to all table in schema with PostgreSQL?

I have a database my_database, and it have some tables named my_table_1, my_table_2, ... , my_table_128 under schema public. I need to grant select privileges for all tables in schema public to user my_db_user, so I execute SQL command below: GRANT…
fajin yu
  • 195
  • 3
  • 10
1
vote
0 answers

Advantages of Microsoft Enterprise Mode Schema v.2 over v.1?

Title explains it really. The company I work for is considering changing their Enterprise Schema from v.1 to v.2. I am aware that there are structural changes to the coding, however I am not aware of any prominent advantages. From a performance…
AODonnell95
  • 19
  • 2
1
vote
1 answer

Using PrepareSchema on existing Exchange 2007 Server - Mailboxes have PROTECTED INHERIT flag

I was trying to create a new Receive Connector on my older Exchange 2007 SP3 server (planning underway to upgrade later this year) and when it failed I did some research. The solution I found Here (I got the exact same error) included running…
ItsPronounced
  • 634
  • 4
  • 18
  • 40
1 2
3
4 5 6 7 8